Skip to content

Instantly share code, notes, and snippets.

@saostad

saostad/MS-SQL-SERVER-Create-Unique-Index-Accept-Null

Created August 13, 2019 13:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save saostad/ac40006030ff079af402ade8e7ce23d5 to your computer and use it in GitHub Desktop.
Save saostad/ac40006030ff079af402ade8e7ce23d5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MS-SQL-SERVER-Create-Unique-Index-Accept-Null
CREATE UNIQUE NONCLUSTERED INDEX INDEX_NAME_HERE
ON TABLE_NAME_HERE(FIELD_NAME_HERE)
WHERE FIELD_NAME_HERE IS NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment