SQLServerCentral.com Scripts tagged T-SQL Aids, SQLInsider Scripts, Miscellaneoushttp://www.sqlservercentral.com/Scripts tagged T-SQL Aids, SQLInsider Scripts, Miscellaneous posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Counter Table (table of numbers) Setter-Upper for SQL Server 2005Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/Counter Table (table of numbers) Setter-Upper for SQL Server 2000Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/LSTR() and RSTR(): Enhanced LEFT() and RIGHT()http://www.sqlservercentral.com/scripts/Miscellaneous/32002/2007/09/13http://www.sqlservercentral.com/scripts/Miscellaneous/32002/Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/Table row count using 3 different wayshttp://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/Send SMS from a triggerhttp://www.sqlservercentral.com/scripts/Miscellaneous/31899/2007/04/16http://www.sqlservercentral.com/scripts/Miscellaneous/31899/Script SQL Database DDLhttp://www.sqlservercentral.com/scripts/Miscellaneous/31882/2007/03/12http://www.sqlservercentral.com/scripts/Miscellaneous/31882/Calculating Percentage Changehttp://www.sqlservercentral.com/scripts/Miscellaneous/31868/2007/03/02http://www.sqlservercentral.com/scripts/Miscellaneous/31868/Proper Luhn AddCheckDigit for any length #http://www.sqlservercentral.com/scripts/Miscellaneous/31813/2006/01/12http://www.sqlservercentral.com/scripts/Miscellaneous/31813/Stored Proc to List Columns for a Primary Keyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31794/2006/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/31794/Random Number Generatorhttp://www.sqlservercentral.com/scripts/Miscellaneous/31793/2006/09/15http://www.sqlservercentral.com/scripts/Miscellaneous/31793/Overcome BCP limitations for output to CSV filehttp://www.sqlservercentral.com/scripts/Miscellaneous/31756/2006/07/03http://www.sqlservercentral.com/scripts/Miscellaneous/31756/MIME64 Encoder and Decoder written in T-SSQLhttp://www.sqlservercentral.com/scripts/Miscellaneous/31751/2006/11/09http://www.sqlservercentral.com/scripts/Miscellaneous/31751/Parse a fixed length numeric value from a stringhttp://www.sqlservercentral.com/scripts/Miscellaneous/31748/2006/11/08http://www.sqlservercentral.com/scripts/Miscellaneous/31748/Calculate distance between two pointshttp://www.sqlservercentral.com/scripts/Miscellaneous/31679/2006/05/18http://www.sqlservercentral.com/scripts/Miscellaneous/31679/script to create default class in VB.NEThttp://www.sqlservercentral.com/scripts/Miscellaneous/31655/2006/04/03http://www.sqlservercentral.com/scripts/Miscellaneous/31655/script to create default stored procshttp://www.sqlservercentral.com/scripts/Miscellaneous/31654/2006/04/21http://www.sqlservercentral.com/scripts/Miscellaneous/31654/Create .NET parametershttp://www.sqlservercentral.com/scripts/Miscellaneous/31653/2006/04/24http://www.sqlservercentral.com/scripts/Miscellaneous/31653/List any Object In Any Database On Serverhttp://www.sqlservercentral.com/scripts/Miscellaneous/31620/2006/01/16http://www.sqlservercentral.com/scripts/Miscellaneous/31620/Scripting extended propertieshttp://www.sqlservercentral.com/scripts/Miscellaneous/31607/2006/01/05http://www.sqlservercentral.com/scripts/Miscellaneous/31607/Proper Case Title Case for Last Nameshttp://www.sqlservercentral.com/scripts/Miscellaneous/31572/2005/09/05http://www.sqlservercentral.com/scripts/Miscellaneous/31572/Pad Stringhttp://www.sqlservercentral.com/scripts/Miscellaneous/31558/2005/08/19http://www.sqlservercentral.com/scripts/Miscellaneous/31558/Find Table Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31553/2007/10/23http://www.sqlservercentral.com/scripts/Miscellaneous/31553/Calculate upcoming business day from date (Updated)http://www.sqlservercentral.com/scripts/Miscellaneous/31543/2006/01/19http://www.sqlservercentral.com/scripts/Miscellaneous/31543/move all indexes to a secondary file grouphttp://www.sqlservercentral.com/scripts/Miscellaneous/31541/2006/06/19http://www.sqlservercentral.com/scripts/Miscellaneous/31541/Conversion Functionshttp://www.sqlservercentral.com/scripts/Miscellaneous/31469/2005/04/12http://www.sqlservercentral.com/scripts/Miscellaneous/31469/Verify Directory Exists and Create if Necessaryhttp://www.sqlservercentral.com/scripts/Miscellaneous/31463/2005/03/24http://www.sqlservercentral.com/scripts/Miscellaneous/31463/Sequential Alpha Numeric String Incrementerhttp://www.sqlservercentral.com/scripts/Miscellaneous/31448/2005/09/22http://www.sqlservercentral.com/scripts/Miscellaneous/31448/Create an audit trigger on a tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31241/2004/09/02http://www.sqlservercentral.com/scripts/Miscellaneous/31241/