Update a table column with a sequence number v2.0

In response to Sachinvaishnav's search for a better way to insert a sequence number column in the same table, I bring you a cursor free Sql server 2005 example that utilizes the new ROW_NUMBER() OVER(ORDER BY) Function available in 2005

What will be the result of the last...

Given a SHARED spreadsheet called C:\Test.xls, with three...

Try/Catch Block in SQL Server 2005

Server 2005 now supports a more programmable error trapping convention in T-SQL code. This error handling is known as the TRY/CATCH block. The TRY/CATCH block allows T-SQL to handling errors like other programming languages, such as Microsoft Visual C# and C++. In addition to the TRY/CATCH block, Microsoft has expanded the set of available system functions in SQL Server 2005 for returning error codes and messages when an error occurs in your T-SQL code. This article will explore the new TRY/CATCH block and explain the new system functions for returning error codes and messages.

Script To drop the dependets on a column

This procedure is useful to find the dependents on a particular column in a table and deletes the dependents like 'Index','Relation ships'.This is developed in Sql Server 2005

Both of these statements return "yes" )a blank...

Progressive Sums in T-SQL

A common problem in sql is how to calculate and process, for the current row, information that is based on the results (sum, product, difference, etc) of the rows read so far.A solution (we use) to this problem is to create a self join query based on the primary key using the condition of "greater […]

OPENROWSET function in SQL Server 2005

mong other enhancements in SQL Server 2005, enhancements were made to the OPENROWSET function. This article illustrates BULK operations of the OPENROWSET function.

You are writing a software add-on for SQL...

Boost Performance and Reduce Code Use With SQL Server Aggregate Functi

This article will acquaint you with aggregate functions such as MIN, MAX, COUNT, and AVG, which easily let you perform tasks that you may have thought needed extensive programming codes to accomplish.