1.Write the script to create Table. Answer: CREATE TABLE Test ( ID int, LastName varchar(255), FirstName varchar(255), Address varchar(100), ); 2. What is Primary Key Constraint? Answer: The PRIMARY KEY constraint uniquely identifies each record in a database table. It must contain unique values and must not contain null values. Most of the tables should … Continue reading SQL Server Interview Questions and Answers for Mid Level →