http://www.sqlservercentral.com/Scripts tagged T-SQL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)A 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/05/13http://www.sqlservercentral.com/scripts/Miscellaneous/63094/A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.http://www.sqlservercentral.com/scripts/T-SQL/62978/2008/04/30http://www.sqlservercentral.com/scripts/T-SQL/62978/This a function by which you can calculate the age of something.http://www.sqlservercentral.com/scripts/T-SQL/62794/2008/04/10http://www.sqlservercentral.com/scripts/T-SQL/62794/Here is a short UDF to URL encode a string. Requires a numbers table.http://www.sqlservercentral.com/scripts/URL/62679/2008/03/27http://www.sqlservercentral.com/scripts/URL/62679/A function to calculate the date for Easter Sunday for a given yearhttp://www.sqlservercentral.com/scripts/T-SQL/62633/2008/03/24http://www.sqlservercentral.com/scripts/T-SQL/62633/This allows a player to play tic tac toe against an automated computer.http://www.sqlservercentral.com/scripts/TSQL/62384/2008/03/11http://www.sqlservercentral.com/scripts/TSQL/62384/How to remove duplicate records from a table.http://www.sqlservercentral.com/scripts/T-SQL/62352/2008/04/18http://www.sqlservercentral.com/scripts/T-SQL/62352/This procedure prepares a query for generating permutations of n-numbers set and executes it.http://www.sqlservercentral.com/scripts/Miscellaneous/62164/2008/03/18http://www.sqlservercentral.com/scripts/Miscellaneous/62164/Enable Disable All Triggers in a Databasehttp://www.sqlservercentral.com/scripts/T-SQL/62092/2008/03/20http://www.sqlservercentral.com/scripts/T-SQL/62092/It shows the Calender.http://www.sqlservercentral.com/scripts/T-SQL/62091/2008/03/14http://www.sqlservercentral.com/scripts/T-SQL/62091/Tool to automatically query combinations of columns in your table to determine candidate for unique key.http://www.sqlservercentral.com/scripts/T-SQL/62086/2008/04/16http://www.sqlservercentral.com/scripts/T-SQL/62086/Reports on physical size of tables in your database to identify largest.http://www.sqlservercentral.com/scripts/T-SQL/62053/2008/03/13http://www.sqlservercentral.com/scripts/T-SQL/62053/Parses up & down the dependency chain of an objecthttp://www.sqlservercentral.com/scripts/T-SQL/61941/2008/02/26http://www.sqlservercentral.com/scripts/T-SQL/61941/Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.http://www.sqlservercentral.com/scripts/T-SQL/61875/2008/03/07http://www.sqlservercentral.com/scripts/T-SQL/61875/When using the output for generated code don't forget the titlehttp://www.sqlservercentral.com/scripts/T-SQL/61812/2008/02/18http://www.sqlservercentral.com/scripts/T-SQL/61812/Modify columns' name in batches.http://www.sqlservercentral.com/scripts/T-SQL/61800/2008/02/14http://www.sqlservercentral.com/scripts/T-SQL/61800/Use this proc if you need to alter a column that is part of a primery keyhttp://www.sqlservercentral.com/scripts/Referential+Integrity/61707/2008/02/04http://www.sqlservercentral.com/scripts/Referential+Integrity/61707/Sample solution to replace string in expressions with multiple delimiters.http://www.sqlservercentral.com/scripts/String+Manipulation/61685/2008/01/31http://www.sqlservercentral.com/scripts/String+Manipulation/61685/Refresh All views in Current Database.http://www.sqlservercentral.com/scripts/T-SQL/61674/2008/01/28http://www.sqlservercentral.com/scripts/T-SQL/61674/Like my tdard split but this will take a string and split it by 2 delimitershttp://www.sqlservercentral.com/scripts/String+Manipulation/61509/2007/12/28http://www.sqlservercentral.com/scripts/String+Manipulation/61509/Search entire database for occurrence of any text!http://www.sqlservercentral.com/scripts/Search/61508/2007/12/31http://www.sqlservercentral.com/scripts/Search/61508/This proc generates SELECT, UPDATE, INSERT, and DELETE procs for any given table.http://www.sqlservercentral.com/scripts/Automation/61488/2008/01/02http://www.sqlservercentral.com/scripts/Automation/61488/This script helps you to constitute insertion procedures for tables in a millisecond.http://www.sqlservercentral.com/scripts/Table/61472/2008/01/03http://www.sqlservercentral.com/scripts/Table/61472/Using this script you can create a list of sql commands for foreign keys manipulation.http://www.sqlservercentral.com/scripts/T-SQL/61463/2008/01/08http://www.sqlservercentral.com/scripts/T-SQL/61463/Four bit manipulation functions: 1. Turn bit ON 2. Turn bit OFF 3. Check if bit is ON 4. Toggle bit ON/Offhttp://www.sqlservercentral.com/scripts/T-SQL/61457/2007/12/25http://www.sqlservercentral.com/scripts/T-SQL/61457/Grant permits execution to all user on all sp and functionshttp://www.sqlservercentral.com/scripts/Security/61408/2008/01/04http://www.sqlservercentral.com/scripts/Security/61408/Display row value as a TABLE column using SQL select statementhttp://www.sqlservercentral.com/scripts/T-SQL/61407/2007/12/24http://www.sqlservercentral.com/scripts/T-SQL/61407/You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Casthttp://www.sqlservercentral.com/scripts/Datetime+Manipulation/61393/2008/02/01http://www.sqlservercentral.com/scripts/Datetime+Manipulation/61393/This Script generates drop and create scripts for views or stored procedures.http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/2008/01/14http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/Sometimes you need to empty the content of database. Following script can do that for you.http://www.sqlservercentral.com/scripts/T-SQL/61312/2007/10/15http://www.sqlservercentral.com/scripts/T-SQL/61312/