SQLServerCentral: Scripts tagged T-SQL

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

Scripts with tag T-SQL