In SQL Server, the CHOOSE function returns the item at the provided index from a list of values. CHOOSE is an index into an array,
Category: SQL Server
SQL Server Administration, Development and Maintenance
Renaming a column in SQL Server
Although renaming a column is extremely uncommon, SQL Server provided us with the ability to do so in the event that it was required. I
CHECKSUM and CHECKSUM_AGG
CHECKSUM: The checksum value computed over a table row or an expression list is returned by the CHECKSUM function. To create hash indexes, use CHECKSUM.
STRING_AGG Function in SQL Server
This function is introduced in SQL Server 2017 (14x) concatenates the values of string expressions and places separator values between them. The separator is not
STRING_ESCAPE Function – SQL Server
Escapes special characters in texts and returns text with escaped characters. STRING_ESCAPE is a deterministic function, which means it always return the same result any time
Translate & Replace functions in SQL Server
This article introduces the new TRANSLATE and REPLACE string functions in SQL Server look identical, shifting letters from one to the other. There is a
Big Data & SQL 