Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Steven Willis

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Parse XML to table

A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.  Read more...
By Steven Willis 2013/08/05 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,574 reads

Virtual tally table function

An inline table-valued function (iTVF) that will produce a virtual tally table on-the-fly. The function creates a tally table of any size with user-defined lower and upper bounds.  Read more...
By Steven Willis 2014/09/08 | Source: SQLServerCentral.com | Category: tally
Rating: |  Discuss |   Briefcase | 1,875 reads

Find the position of all occurrences of an expression within a string

This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.  Read more...
By Steven Willis 2013/04/12 | Source: SQLServerCentral.com | Category: charindex
Rating: |  Discuss |   Briefcase | 944 reads

Generate Column Metadata

This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.  Read more...
By Steven Willis 2013/02/12 | Source: SQLServerCentral.com | Category: utility
Rating: |  Discuss |   Briefcase | 600 reads
   Items 1 to 4 of 4