|
|
|
|
-
John Madden Liked 7 Months ago through Blogs | 1 Point
I have already posted blog posts regarding the proper usage of the alias name
http://beyondrelational.com/blogs/madhivanan/archive/2007/11/14/should-alias-names-be-preceded-by-as.aspx http://beyondrelational.com/blogs/madhivanan/archive/2008/09/09/sho...
|
-
John Madden learned 7 Months ago through Blogs | 1 Point
I have already posted blog posts regarding the proper usage of the alias name
http://beyondrelational.com/blogs/madhivanan/archive/2007/11/14/should-alias-names-be-preceded-by-as.aspx http://beyondrelational.com/blogs/madhivanan/archive/2008/09/09/sho...
|
-
John Madden Liked 2 Years ago through Blogs | 1 Point
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter and more efficient ways to do things – and that is spot on what I’ll do today.
Finding the time when SQL Server was last restarted, and using th...
|
-
John Madden Liked 2 Years ago through Blogs | 1 Point
When you generate an XML document using FOR XML, columns having NULL value will be eliminated. Some times you might need to have an empty element (even if there is no value) generated to make sure that the application that processes the XML document doe...
|
-
John Madden Liked 2 Years ago through Blogs | 1 Point
One of the most interesting error handling enhancements added in SQL Server 2005 is the support for structured exception handling using TRY / CATCH blocks. This reduced the complexity of error handling in TSQL significantly. Exception Handling using T...
|