Because some of the parts of the query vary based on certain situations I construct a string that contains the query and then use the exec() function to execute the query.<P>My problem is that the ...

SQL Server 2012 was released last April, making it the 11th major release of the product. Every new version has delivered new functionality that should excite developers, and this release is no ...

Here's a scenario where the IIF statement is nested to two levels. As you can tell, it gets a little difficult to read with the nesting; so, although possible, it's not always recommended. The fourth ...