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

Scripts by Steven Willis 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 2015/04/08 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 4,180 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: | Category: tally
Rating: |  Discuss |   Briefcase | 2,011 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 2015/05/12 | Source: | Category: charindex
Rating: |  Discuss |   Briefcase | 1,928 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: | Category: utility
Rating: |  Discuss |   Briefcase | 664 reads
   Items 1 to 4 of 4