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.

Display Person Initials

Display a person's initials regardless if they have a middle name or not.Just pass in the persons name

Analyze a Table Contents

Analyze a table contents for type of information. Returns the number of distinct values for each field and the list and frequency of those values when specified