SQL Server Nation
For all of your SQL Server needs.

April 2009 - Development

Sort by: Most Recent | Most Viewed | Most Commented

  • Two things I love about Management Studio 2008

    I've been using the SQL Server product for quite some time now, and I almost always use the IDE programs that ship with the database engine. Enterprise Manager and Query Analyzer certainly had their quicks, but were overall nice tools. Management Studio 2005 was a great improvement over these tools because it integrated Enterprise Manager and Query Analyzer into one tool, and it added some neat bells and whistles. Now that Management Studio 2008 is out, there are two really neat new features...

  • Using TRY...CATCH IN SQL Server 2005/2008

    New to SQL Server 2005 (and present in SQL Server 2008) is the ability to use TRY..CATCH constructs inside of your TSQL code to catch error statements. If you've done any type of programming in other programming languages, you know that this is a very handy tool to have. Whats even better in my opinion is the ability to write a generic error handling procedure you can use inside of your CATCH blocks to capture and record errors when they occur. So, lets take a look at how we can take advantage...
Copyright SQL Server Nation 2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems