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.
2015-05-12 (first published: 2013-03-24)
2,186 reads
Steven Willis
Parse XML to table
A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.
2015-04-08 (first published: 2013-07-09)
5,156 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.
2014-09-08 (first published: 2013-06-28)
2,217 reads
Generate Column Metadata
This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.
2013-02-12 (first published: 2013-01-18)
731 reads
Blogs
Saving Emergency Space on my Laptop
By Steve Jones
With my new laptop, one of the things I realized I’d forgotten to do...
T-SQL Tuesday #178–A Recent Technical Problem
By Steve Jones
This month we have a good invitation from Deepthi Goguri, where she asks us...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
talend "template" feature vs ssis
Hi we will be using a talend template shortly to abstract the schema definition...
Question of the Day
Setting Emergency State
Which server role(s) can set a database to the Emergency State?
See possible answers