The OUTPUT clause was introduced in SQL Server 2005. The OUTPUT clause returns the values of each row that was affected by an INSERT, UPDATE, or DELETE statement. It even supports a MERGE statement, which was introduced in SQL Server 2008 version. The OUTPUT clause has access to two temporary or in-memory SQL tables, INSERTED […]
Tag: new
How to set hyperlink to open in new window in Reportviewer
The MSDN lists supported HTML in SSRS, quoting that article: • Hyperlinks: <A HREF> • Fonts: <FONT> • Header, style and block elements: <H{n}>, <DIV>, <SPAN>, <P>, <DIV>, <LI>, <HN> • Text format: <B>, <I>, <U>, <S> • List handling: <OL>, <UL>, <LI> Only the href attribute on a tag is supported. That means target attribute will be ignored. To set hyperlink to open in new window in Reportviewer, you must set the “HyperlinkTarget” property of Reportviewer […]
What does the word ‘new’ mean exactly in C#?
In C# (and many other languages) you will find that you use new often as it is fundamental to using types and classes. The new keyword does pretty much what it says: it will create a new instance of a class or type, assigning it a location in memory. Let me try and illustrate this. Company company; Here […]