How to assign check constraint a Name for multiple columns in Sql Server?

Posted by vishalneeraj-24503 on 9/1/2014 | Category: Sql Server Interview questions | Views: 1235 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Refer below script:-

Create Table Employee_Master

(

  Employee_Id int not null Constraint ck_employee Check([PAN_Number] Is Not Null),

  First_Name varchar(100) not null,

  Middle_Name varchar(100),

  Last_Name varchar(100) not null,

  Employee_Name varchar(100) not null,

  PAN_Number varchar(10) not null,

  LDAP varchar(10) not null

  )

)

Asked In: Many Interviews | Alert Moderator