This is a port of the SPLIT function from Perl (or VBScript). It works the same way: pass a string anda separator, up to 4 characters long (you can change this),and the function returns a table with the elements.This version trims leading and trailling spaces of the elements, just for convenience.Example:SELECT strvalFROM master.dbo.SPLIT('a and b', […]
2003-06-13
204 reads
Here is a port from the Oracle's TRANSLATE function to T-SQL. It gets three arguments: a string to be searched, a string with a set of characters to be found and replaced, and another set of characters as the replacements. Example: SELECT dbo.TRANSLATE('ABCDE', 'BD', 'CE') It will return 'ACCEE'.
2002-01-03
464 reads
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
Hello DB Gurus, Business wants to have minimum downtime cutover from SQL Server 2008...
I am trying to configure polybase scale out, what ports do you recommend? Is...
This script reads thru a file and removes the last line, but before it...
Ask SSC