Home • Database • Microsoft SQL Server
Create a unique constraint that also allows nulls in MSSQL Server
- CREATE UNIQUE NONCLUSTERED INDEX uni_lot_master_doc_ref
- ON item_lot_master(doc_ref)
- WHERE doc_ref IS NOT NULL;
About Author
- University
- Online Tips
- Engineering
- Programming
- General Subjects
- Science
- News
- Jobs
- Commerce
- General Knowledge
- Story, Tales & Poem
- Software Application
- Framework
- Operating System
- Database
- Networking
- Quiz
- Generic POS + ERP
Comments 0