Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Unique constraint Rss

   Items 1 to 3 of 3   

Declarative SQL: Using UNIQUE Constraints

In SQL, you can express the logic of what you want to accomplish without spelling out the details of how the database should do it. Nowhere is this more powerful than in constraints. SQL is declarative, and Joe Celko demonstrates, in his introduction to Declarative SQL, how you can write portable code that performs well and executes some complex logic, merely by creating unique constraints.  Read more...
By Additional Articles 2015/12/29 | Source: SimpleTalk | Category: unique constraint
Rating: (not yet rated)  Rate this |   Briefcase | 6,288 reads

Use of Key Column

By Bilal Mahmood 2013/05/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,120 reads


By Chirag Patel 2013/01/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,589 reads
   Items 1 to 3 of 3   
t-sql (2)    
indexing (1)    
primary key (pk) (1)