Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //I tried 4 version OF this code:
- CREATE UNIQUE NONCLUSTERED INDEX [BidContractNumber_UNIQUE]
- ON [biddetails] (BidContractNumber) WHERE [biddetails].[BidContractNumber] IS NOT NULL;
- CREATE UNIQUE NONCLUSTERED INDEX [BidContractNumber_UNIQUE]
- ON [biddetails] (BidContractNumber) WHERE NOT((BidContractNumber) IS NULL);
- CREATE UNIQUE INDEX BidContractNumber_UNIQUE
- ON biddetails (BidContractNumber) WHERE [BidContractNumber] IS NOT NULL;
- CREATE UNIQUE INDEX BidContractNumber_UNIQUE
- ON biddetails (BidContractNumber) WHERE [BidContractNumber] IS NOT NULL;
- /*
- But I'm getting this error :
- Msg 156, Level 15, State 1, Line 2
- Incorrect syntax near the keyword 'WHERE'.
- I'm using sql server 2005
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement