what is Primary Key in SQL Server

Answer:

A Primary Key in a table uniquely identifies each and every row with out allowing Nulls. There are two types of Primary Keys:

1) Simple Primary Key ==> Defining primary key on a single column is called Simple Primary Key.
2) Composite Primary Key ==> Defining Primary Key on more than one column is called Composite Primary Key.