Jignesh Raiyani
Database Collation

SQL Server collation introduction with collate SQL casting

January 27, 2020 by

SQL Server collation refers to a set of character and character encoding rules, and influences how information is stored according to the order in the data page, how data is matched by comparing two columns, and how information is arranged in the T-SQL query statement. Collate SQL follows rules applied on a table when Select, Insert, Update or Delete operations are performed against contained data. Data always follows collation constraint rules, which are configured when creating an object.

Read more »

Best author award in 2019

January 3, 2020 by

2019 was a great year for the SQL Shack community, and 2020 is shaping up to be just as exciting. Thanks to our writers – SQL professionals and community members, we continue to spread the knowledge around the SQL community.

Read more »