Split String Function
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
4,948 reads
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
4,948 reads
This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently
2016-08-08 (first published: 2014-12-29)
7,699 reads
2015-08-10 (first published: 2015-07-16)
1,515 reads
I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.
2013-05-13 (first published: 2013-05-03)
1,039 reads
In this post we're going to go through the steps to set up Always...
I’ve been using Azure SQL Database for quite some while and have set up...
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
The table InventDim has some indexes, we create one index idx1 which has index...