While SQL Server Management Studio is a powerful tool for writing queries, it has absolutely no concessions towards making the results of those queries remotely presentable! This blog describes several techniques for getting the results of a query into another application so that you can format them to your heart’s content.
This mini-blog provides a means to generate the database used by our online ASP.NET tutorial.
In a previous blog on new features of SQL 2012
, I missed out the ability to insert code snippets, and also to embed or surround
code in an IF
block. This blog rectifies this!
SQL 2012 has 14 new functions, a new FileTable construct and new ways to sequence and fetch records - as this blog explains.