Post a Comment On: Blogpad

-- To create a unique index: IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = N'IX_ClientsTable_ClientID_Name') BEGIN -- ClientID and Name will be unique per row CREATE UNIQUE INDEX IX_ClientsTable_ClientID_Name ON ClientsTable (ClientID, [Name]) END GO