You need to update a large number of...

Updating multiple rows using single stored proc

The situation arises when we are displaying data in a grid or some other control at front end level, where the user is making corresponding changes in the grid and at last when the user click for update button, the whole changes should be posted back to the database. This can be achieved by two […]

This is the data in the Orders table:

OrderID...

From a Delimited String, fetching the nth Value

This User defined Function will provide you the facility of fetching the nth Value from a Delimited string. The Parameter for the function which you have to pass is, the Delimited String, the Delimiter of the string, nth Position of the string. In this function , you can dynamically change the Delimiter as well as […]

Modification to Automate Audit Trigger Generation

This is a modification to Automate Audit Trigger Generation at http://www.sqlservercentral.com/scripts/contributions/1073.asp by walkerjet. The changes were made to accommodate tables using different types for their primary keys, (i.e. int, smallint, char, etc.), add the ModifiedById and DTStamp columns, exclude legacy tables that do not have a primary key defined, exclude fields of type text, ntext, […]

Select from x th row next y rows

This code will show rows from 17th and then next 3 ordered by name from table authors in database pubs. Table must have primary key and of course ordered column. You can change value 'from' in line 'SET ROWCOUNT 17' and value 'next' (how many rows)in line SELECT TOP 3. It is good to show […]

Why would this statement fail? (SQL 7 and...

This is the data in the myOrders table

Order_No...

Counting occurrences of a substring in a string

Modification of the script entitled "Counting occurrences in a string" by thomasun.This version, packaged as a UDF, is not limited to searching for single characters - substrings can be counted.

Detect Object dependencies.

This stored procedure will detect all first level object dependencies on Stored Procedure.The result set will be stored in table Depend. Unlike sp_depends, sp_MSdependencies will be able to detect all links and dependencies associated to an object. It includes TRIGGER, DELETE, UPDATE etc .