SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Scripts with tags SQL Server 2005, SQL Server 2000, T-SQL Aids Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (4)     Delimited Strings (3)     Parsing (3)     Table of Numbers (3)    
Advanced Querying (3)     Development (3)     SQLInsider Scripts (3)     tally (3)    
Arrays (3)     nums (3)     String Manipulation (3)     Miscellaneous (1)    
counter (3)    

Search for any content tagged SQL Server 2005 & SQL Server 2000 & T-SQL Aids

Add a script

   Items 1 to 5 of 5   
 

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...
By Jesse Roberge 2008/10/23 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: (not yet rated) |  Discuss |  Briefcase | 88 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
Rating: (not yet rated) |  Discuss |  Briefcase | 42 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: (not yet rated) |  Discuss |  Briefcase | 67 reads

Proc to Rename a file

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.  Read more...
By Simon Facer 2008/06/17 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,070 reads

Check Instance Info

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.  Read more...
By Pedro Lopes 2007/12/19 | Source: SQLServerCentral.com | Category: SQL Server 2000
Rating: |  Discuss |  Briefcase | 1,298 reads
   Items 1 to 5 of 5