TSQL String Split

Examples A. Split comma-separated value string Parse a comma-separated list of values and return all non-empty tokens. STRING_SPLIT will return empty string if there is nothing between separator. Condition RTRIM(value) <> ” will remove empty tokens. B. Split comma-separated value string in a column Product table has a column with comma-separate list of tags shown... » read more

TSQL Encrypt By Pass Phrase

Encrypt data with a passphrase using the TRIPLE DES algorithm with a 128 key bit length. Sources: https://docs.microsoft.com/en-us/sql/t-sql/functions/encryptbypassphrase-transact-sql?view=sql-server-2017