25.Collation in SQL Server 2019
in this video, we are going to see how to change Column level collation and Database collation
To Alter Column level collation :
ALTER TABLE COLLATION_TABLE
ALTER COLUMN NAME VARCHAR(100)
COLLATE Latin1_General_CI_AS
To Change Database level Collation :
ALTER DATABASE COLLATION_TABLE
COLLATE SQL_Latin1_General_CP1_CS_AS
