Hoofdlettergevoeligheid in SQL Server 2005

DECLARE @CurrName varchar(50)
, @NewName varchar(50)
SELECT @CurrName = 'test', @NewName = 'Test'

-- Hoofdletterongevoelig, accentongevoelig
IF @NewName = @CurrName COLLATE SQL_Latin1_General_Cp1_CI_AI
SELECT 'Gelijk' AS result
ELSE
SELECT 'Verschillend' AS result
-- 'result = 'Gelijk'

-- Hoofdlettergevoelig, accentgevoelig
IF @NewName = @CurrName COLLATE SQL_Latin1_General_Cp1_CS_AS
SELECT 'Gelijk' AS result
ELSE
SELECT 'Verschillend' AS result
-- 'result = 'Verschillend'