SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag T-SQL Rss

Search for any content tagged t-sql

   Items 1 to 20 of 161    Next 20 >>
 

Credit Card Number Validation Escalar Function

Evaluate credit card numbers based on ISO 2894 algorithm.  Read more...
By thor the viking 2010/03/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 46 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: admin
Rating: |  Discuss |  Briefcase | 1,128 reads

usp_TransposeNRows v2.0

Transpose N rows of a table (v2.0 allows user to specify the table's schema)  Read more...
By j.d.brooks 2010/02/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 795 reads

Script to get Server Info

This script will gather a number of Server Information items that are useful in baselining a SQL Server.   Read more...
By Pradyothana Shastry 2010/02/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 2,401 reads

usp_TransposeNRows

Stored procedure to transpose the first N rows of a specified table  Read more...
By j.d.brooks 2010/02/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 758 reads

Script Table or View structure

This code will let you script a Table or Views structure for source control.   Read more...
By Pratap Prabhu 2010/02/02 | Source: SQLServerCentral.com | Category: scripting
Rating: |  Discuss |  Briefcase | 1,154 reads

Implementing Most Recently Used Lookups

This script will adapt ordering of look-up lists by foreign key usage.  Read more...
By William Talada 2010/01/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 572 reads

Store Procedure Output in a Table

This script show a demonstration of how to interst tore Procedure Output in a Table.  Read more...
By Vinay Kumar 2010/01/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 1,453 reads

Find weak login passwords in your server

Use this script to search for SQL Server logins who use weak password  Read more...
By Th Tr 2010/01/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 2,055 reads

Synchronize all stored procedures between two servers

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.  Read more...
By Th Tr 2009/12/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 1,289 reads

Synchronize a function between two servers

It's the same with spSynchStoredProcedure  Read more...
By Th Tr 2009/12/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 357 reads

Synchronize a view between two servers

This script is the same with spSynchStoredProcedure  Read more...
By Th Tr 2009/12/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 359 reads

Synchronize several stored procedure between two servers

Synchronize source code between two servers for multiple stored procedures  Read more...
By Th Tr 2009/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 746 reads

Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers.  Read more...
By Th Tr 2009/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 1,004 reads

t-sql first last day date of the month

Returns the First or last day date of the month for a given date.  Read more...
By Bernabe Diaz 2009/12/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 1,803 reads

syscolumns names

get a list of syscolumns names from string comma separated columns list  Read more...
By Bernabe Diaz 2009/12/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 466 reads

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...
By Thomas Cournane 2009/12/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 935 reads

Drive Letter Finder

Find the first available drive letter (working backwards from z)  Read more...
By DASUN 2009/11/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 581 reads

Wait for Mirror treshold

This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.  Read more...
By Wilfred van Dijk 2009/11/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 251 reads

Search in your T-SQL objects

This procedure searches for your criteria not only in code, but also in objectnames  Read more...
By Wilfred van Dijk 2009/11/16 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |  Briefcase | 787 reads
   Items 1 to 20 of 161    Next 20 >>