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,007 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)
4,856 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,173 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)
708 reads
Blogs
Daily Coping 22 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Altering a Computed Column in a Temporal Table in Azure SQL
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...
Basic OFFSET–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
SQL Server 2016 SP1 to SP2
We are currently on SQL server SP1. Should we go ahead and apply SP2? ...
Cant cast VARCHAR(MAX) To XML Variable
Hi there I would like to cast a NVARCHAR(MAX) variable string to an XML...
SQL server 2019 reporting need help
Hello sql server reporting 2019, i created temp for 180 days and not sure...
Ask SSC