SQL Server中的区分大小写的变量

DECLARE @MyVariable NVARCHAR(50) = 'Hello World'
DECLARE @LowerCaseVariable NVARCHAR(50) = LOWER(@MyVariable)
DECLARE @UpperCaseVariable NVARCHAR(50) = UPPER(@MyVariable)

SELECT @LowerCaseVariable AS LowerCaseVariable, @UpperCaseVariable AS UpperCaseVariable

LowerCaseVariable | UpperCaseVariable
------------------ | ------------------
hello world        | HELLO WORLD

DECLARE @String1 NVARCHAR(50) = 'Hello'
DECLARE @String2 NVARCHAR(50) = 'hello'

IF @String1 = @String2 COLLATE Latin1_General_CS_AS
    PRINT 'Strings are equal'
ELSE
    PRINT 'Strings are not equal'

Strings are not equal