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
217 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
476 reads
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Want to blend your love of marketing with the power of data? Becoming a...
I live for questions and this was an interesting one. Can you see Table...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
What the required permissions are for "Database import" on an Azure SQL database ...
Hi All, Is there a way i can create package for an individual...
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers