SQLServerCentral.com Scripts tagged Miscellaneous, T-SQL Aidshttp://www.sqlservercentral.com/Scripts tagged Miscellaneous, T-SQL Aids 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/Proc to Rename a fileA simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.http://www.sqlservercentral.com/scripts/Miscellaneous/63094/2008/06/17http://www.sqlservercentral.com/scripts/Miscellaneous/63094/Effectively mapping primary key – foreign key relationsThis script maps the primary key - foreign key relations regardless if the column names are the same or not.http://www.sqlservercentral.com/scripts/Miscellaneous/61481/2008/01/10http://www.sqlservercentral.com/scripts/Miscellaneous/61481/Combine multiple rows into single outputhttp://www.sqlservercentral.com/scripts/Miscellaneous/32004/2007/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/32004/LSTR() and RSTR(): Enhanced LEFT() and RIGHT()http://www.sqlservercentral.com/scripts/Miscellaneous/32002/2007/09/13http://www.sqlservercentral.com/scripts/Miscellaneous/32002/This SP will be create C# classes using all table http://www.sqlservercentral.com/scripts/Miscellaneous/31997/2007/11/13http://www.sqlservercentral.com/scripts/Miscellaneous/31997/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/Display disk space stats for each tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31988/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31988/Get Record Count for each table in a database.http://www.sqlservercentral.com/scripts/Miscellaneous/31987/2007/08/21http://www.sqlservercentral.com/scripts/Miscellaneous/31987/Table row count using 3 different wayshttp://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/Locate primary key - foreign key relationshttp://www.sqlservercentral.com/scripts/Miscellaneous/31983/2007/11/07http://www.sqlservercentral.com/scripts/Miscellaneous/31983/Create Log tables and Triggershttp://www.sqlservercentral.com/scripts/Miscellaneous/31979/2007/10/26http://www.sqlservercentral.com/scripts/Miscellaneous/31979/Function to Split Multivalued Parameterhttp://www.sqlservercentral.com/scripts/Miscellaneous/31971/2007/10/11http://www.sqlservercentral.com/scripts/Miscellaneous/31971/Row count of all tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/31965/2007/07/20http://www.sqlservercentral.com/scripts/Miscellaneous/31965/Find Column Name Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31964/2007/10/22http://www.sqlservercentral.com/scripts/Miscellaneous/31964/Find Column Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31963/2007/10/10http://www.sqlservercentral.com/scripts/Miscellaneous/31963/Display results VERTICALLY in Results windowhttp://www.sqlservercentral.com/scripts/Miscellaneous/31935/2007/05/21http://www.sqlservercentral.com/scripts/Miscellaneous/31935/Get record count for every table in a databasehttp://www.sqlservercentral.com/scripts/Miscellaneous/31927/2007/05/24http://www.sqlservercentral.com/scripts/Miscellaneous/31927/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/Set Proper Name Case Functionhttp://www.sqlservercentral.com/scripts/Miscellaneous/31912/2007/04/24http://www.sqlservercentral.com/scripts/Miscellaneous/31912/Send SMS from a triggerhttp://www.sqlservercentral.com/scripts/Miscellaneous/31899/2007/04/16http://www.sqlservercentral.com/scripts/Miscellaneous/31899/List of RTA numbers based on the lucky number you http://www.sqlservercentral.com/scripts/Miscellaneous/31886/2007/04/04http://www.sqlservercentral.com/scripts/Miscellaneous/31886/Script SQL Database DDLhttp://www.sqlservercentral.com/scripts/Miscellaneous/31882/2007/03/12http://www.sqlservercentral.com/scripts/Miscellaneous/31882/GetDateTimeOfIsoWeekhttp://www.sqlservercentral.com/scripts/Miscellaneous/31879/2007/03/15http://www.sqlservercentral.com/scripts/Miscellaneous/31879/RC4 encryption/decryption with SQL Serverhttp://www.sqlservercentral.com/scripts/Miscellaneous/31877/2007/08/29http://www.sqlservercentral.com/scripts/Miscellaneous/31877/Splitting stringshttp://www.sqlservercentral.com/scripts/Miscellaneous/31876/2007/08/28http://www.sqlservercentral.com/scripts/Miscellaneous/31876/PARSENAME Enhancementhttp://www.sqlservercentral.com/scripts/Miscellaneous/31875/2007/08/27http://www.sqlservercentral.com/scripts/Miscellaneous/31875/Delete Duplicateshttp://www.sqlservercentral.com/scripts/Miscellaneous/31872/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31872/Calculating Percentage Changehttp://www.sqlservercentral.com/scripts/Miscellaneous/31868/2007/03/02http://www.sqlservercentral.com/scripts/Miscellaneous/31868/