Saturday, October 10, 2015

Update single column to be case-sensitive

ALTER TABLE [table]
ALTER COLUMN [column] [type]
COLLATE SQL_Latin1_General_CP1_CS_AS [NOT NULL]


[NOT NULL] is optional