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
Teradata VM
Teradata is a well-known Relational Database Management System created by the Teradata Corporation. Using the concept of parallelism, Teradata is used to create large-scale data
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
Big Data & SQL 