Function to Split a Delimited String into a Table

This function splits a delimited string (up to 4000 characters long) into a single column table. The delimiter can be specified at the time of execution. If not specified, the delimiter defaults to a comma. The default length of each value is 100, but that can easily be changed.An example for usage:DECLARE @string NVARCHAR(4000)DECLARE @instruments […]

Send SMS from a trigger

Stored Proc to List Columns for a Primary Key

Stored procedure to return the list of columns of the primary key for a table. The name of the column for the result set is the name of the primary key for the table.

List all columns, from a database

This script will list all columns, their datatypes, and sizes from any database.  It can be very useful for contractor DBAs who need to quickly scan all tables, and very helpful for developers, or when you just need a quick list of fields for a meeting.

Generate CROSS-TAB Scripts Automaticly !

Need to Transform a table with Summaries to be plugged into EXCEL or place a table of info in one row. This is cool and has been a real time saver!!! Simply save as a Template file in your favorite template folder. In Query Analyzer go to Menu Tools... Options... General... Note the path of […]