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,508 reads
Chris Kutsch
Calendar Table Function
This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently
2016-08-02 (first published: 2014-12-29)
5,620 reads
2015-08-10 (first published: 2015-07-16)
1,490 reads
Format Currency Into a String
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)
934 reads
Blogs
VMworld 2020 SQL Server session preview
By kleegeek
Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...
A new malware attack on SQL Server
Tencent Security has released a report (written in Chinese) describing a new malware attack by...
Azure Synapse Analytics overlooked features
By James-Serra
There are some options in Azure Synapse Analytics that are not obvious that I...
Forums
SQL Agent error history
Is there a way to capture 2 things, when did the job failed and...
Import csv file into existing table where 1st row has sep=,
Hi, I have a csv file that has the value "sep=," in the first...
Inserts not propagated in transactional replication
Hello, I have a transactional replication configured which subscription fails to sync to often...
Ask SSC