http://www.sqlservercentral.com/Scripts tagged T-SQL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Sample of combination the Distinct clause with Aggregate Functionhttp://www.sqlservercentral.com/scripts/T-SQL/63803/2008/07/23http://www.sqlservercentral.com/scripts/T-SQL/63803/Checking XML indexs with a sample.http://www.sqlservercentral.com/scripts/T-SQL/63781/2008/07/20http://www.sqlservercentral.com/scripts/T-SQL/63781/Using sp_xml_preparedocument and sp_xml_removedocumenthttp://www.sqlservercentral.com/scripts/T-SQL/63780/2008/07/20http://www.sqlservercentral.com/scripts/T-SQL/63780/A script to get the missing index information for a table.http://www.sqlservercentral.com/scripts/T-SQL/63779/2008/07/20http://www.sqlservercentral.com/scripts/T-SQL/63779/Script to return Rows count from table using sp_ExecuteSQLhttp://www.sqlservercentral.com/scripts/T-SQL/63778/2008/07/20http://www.sqlservercentral.com/scripts/T-SQL/63778/Delete duplicate values from tablehttp://www.sqlservercentral.com/scripts/T-SQL/63777/2008/07/20http://www.sqlservercentral.com/scripts/T-SQL/63777/All of us have problems with Duplicate rows, here is a simple and efficient way of removing duplicate rowshttp://www.sqlservercentral.com/scripts/T-SQL/63766/2008/07/18http://www.sqlservercentral.com/scripts/T-SQL/63766/Collect the views and schema per a table!http://www.sqlservercentral.com/scripts/T-SQL/63718/2008/07/15http://www.sqlservercentral.com/scripts/T-SQL/63718/This script gets the f_key and p_key references from and to another tableshttp://www.sqlservercentral.com/scripts/T-SQL/63717/2008/07/15http://www.sqlservercentral.com/scripts/T-SQL/63717/This script gets the object description, and works quicker than sp_helphttp://www.sqlservercentral.com/scripts/T-SQL/63680/2008/07/12http://www.sqlservercentral.com/scripts/T-SQL/63680/This scripts help to format date in different languageshttp://www.sqlservercentral.com/scripts/T-SQL/63669/2008/07/11http://www.sqlservercentral.com/scripts/T-SQL/63669/Searches for actual and potential foreign key columns for a given primary key reference.http://www.sqlservercentral.com/scripts/T-SQL/63509/2008/06/20http://www.sqlservercentral.com/scripts/T-SQL/63509/Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/2008/06/20http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/check public access to extended stored procedureshttp://www.sqlservercentral.com/scripts/T-SQL/63421/2008/06/16http://www.sqlservercentral.com/scripts/T-SQL/63421/Search for GUEST Access Level in all http://www.sqlservercentral.com/scripts/sp_msforeachdb/63420/2008/06/16http://www.sqlservercentral.com/scripts/sp_msforeachdb/63420/T-SQL function to takes a string and produce an integer hashcode matching what is produced by the Java String.hashCode() method.http://www.sqlservercentral.com/scripts/T-SQL/63409/2008/06/11http://www.sqlservercentral.com/scripts/T-SQL/63409/Grant permissions to specific objects in Database using dynamic SQL.http://www.sqlservercentral.com/scripts/Administrator/63399/2008/06/08http://www.sqlservercentral.com/scripts/Administrator/63399/GRANT Column Level Permissionshttp://www.sqlservercentral.com/scripts/T-SQL/63398/2008/06/08http://www.sqlservercentral.com/scripts/T-SQL/63398/Search for String Occurence with this script in your stored procedures.http://www.sqlservercentral.com/scripts/Search/63397/2008/06/08http://www.sqlservercentral.com/scripts/Search/63397/This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/2008/07/09http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/Function that implements the algorithm for calculating the check digit for a UCC/EAN codehttp://www.sqlservercentral.com/scripts/Barcode/63246/2008/07/08http://www.sqlservercentral.com/scripts/Barcode/63246/Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.http://www.sqlservercentral.com/scripts/T-SQL/63241/2008/07/03http://www.sqlservercentral.com/scripts/T-SQL/63241/This is a stored procedure to add a columns to multiple tables, if column doesn't existhttp://www.sqlservercentral.com/scripts/T-SQL/63236/2008/07/01http://www.sqlservercentral.com/scripts/T-SQL/63236/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/06/17http://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/06/09http://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/05/23http://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/05/21http://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/06/02http://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/