search

hoonsbara / octalforty-wizardby

Automatically exported from code.google.com/p/octalforty-wizardby
1 stars 0 forks source link

Add support for SQL Server 2008 filtered indexes #16

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
See http://www.proace.com/2010/02/11/unique-constraints-on-nullable-columns-
in-sql-server-2008/

Basically, extend Wizardby syntax somehow so that this could be performed:

CREATE UNIQUE NONCLUSTERED INDEX User_PinNr_IUC
ON [User] (pinNr)
WHERE pinNr IS NOT NULL

Original issue reported on code.google.com by anton.go...@gmail.com on 20 May 2010 at 3:18

GoogleCodeExporter commented 8 years ago

Original comment by anton.go...@gmail.com on 10 Jun 2011 at 12:56