SQLServerCentral.com Scripts tagged T-SQL Aids, SQLInsider Scriptshttp://www.sqlservercentral.com/Scripts tagged T-SQL Aids, SQLInsider Scripts posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Delimited String Parsing Functions - TwoCol setFeed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/Delimited String Parsing Functions - Big2D setFeed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/Delimited String Parsing Functions - 2D setFeed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/Delimited String Parsing Functions - Big SetFeed it large strings of delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/Delimited String Parsing Functions - Basic SetFeed it delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/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/Verify Errorloghttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31925/2007/09/12http://www.sqlservercentral.com/scripts/T-SQL+Aids/31925/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/AUDIT WITH A TWISThttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31881/2007/03/13http://www.sqlservercentral.com/scripts/T-SQL+Aids/31881/Script SQL Server DDLhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31869/2007/08/20http://www.sqlservercentral.com/scripts/T-SQL+Aids/31869/Calculating Percentage Changehttp://www.sqlservercentral.com/scripts/Miscellaneous/31868/2007/03/02http://www.sqlservercentral.com/scripts/Miscellaneous/31868/Check and Set Default file Locations with TSQLhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31854/2007/01/01http://www.sqlservercentral.com/scripts/T-SQL+Aids/31854/Proper Luhn AddCheckDigit for any length #http://www.sqlservercentral.com/scripts/Miscellaneous/31813/2006/01/12http://www.sqlservercentral.com/scripts/Miscellaneous/31813/Table Variableshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/2006/01/15http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/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/get rich schema details of all or some tableshttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31766/2006/08/30http://www.sqlservercentral.com/scripts/T-SQL+Aids/31766/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/