We frequently deal with names/strings that contain apostrophes or single quotes. It can be difficult to manage them in the database. If we provide the
Category: RDBMS
CHOOSE Function in SQL Server
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,
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
UPSERT in SQL
The UPSERT statement combines the INSERT and UPDATE statements into one statement. If another row with the identical set of primary key values already exists
Big Data & SQL 