Skip to content

Instantly share code, notes, and snippets.

@taylonr
Created December 21, 2011 19:29
Show Gist options
  • Save taylonr/1507324 to your computer and use it in GitHub Desktop.
Save taylonr/1507324 to your computer and use it in GitHub Desktop.
Collation
CREATE TYPE [dbo].[MyRecords] AS TABLE(
[Id] [int] NOT NULL,
[ModuleId] [int] NOT NULL,
[Code] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC,
[ModuleId] ASC,
[Code] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment