You are hereFeed aggregator / Sources / SQLTeam.com
SQLTeam.com
Handling SQL Server Errors
Sun, 04/04/2010 - 17:00This article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005. It includes the usage of common functions to return information about the error and using the TRY CATCH block in stored procedures and transactions.
Categories: SQL Server Expert Blogs
Using REPLACE in an UPDATE statement
Tue, 03/30/2010 - 17:00This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.
Categories: SQL Server Expert Blogs
Efficiently Reuse Gaps in an Identity Column
Mon, 02/08/2010 - 17:00This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.
Categories: SQL Server Expert Blogs
