DDL : MS SQL SERVER QUERIES INTERVIEW QUESTIONS FOR EXPERIENCED DEVELOPER SET-8
DDL RELATED SQL SERVER INTERVIEW QUERIES
This set contains most frequently asked ddl related interview queries, It contains query related to Identity column, Primary key and foreign key.
So lets start: SQL DDL RELATED QUERIES
--78. Write down
the query to create employee table with Identity column([EmployeeID])
--ANS:
--ANS:
CREATE TABLE EmployeeDetail(
[EmployeeID] INT IDENTITY(1,1) NOT NULL, [FirstName] NVARCHAR(50) NULL,
[LastName] NVARCHAR(50) NULL, [Salary] DECIMAL(10, 2) NULL, [JoiningDate]
DATETIME NULL,
[Department] NVARCHAR(20) NULL,
[Gender] VARCHAR(10) NULL)
--79. Write down
the query to create employee table with Identity column([EmployeeID])
--ANS:
--ANS:
CREATE TABLE EmployeeDetail(
[EmployeeID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [FirstName] NVARCHAR(50) NULL,
[LastName] NVARCHAR(50) NULL, [Salary] DECIMAL(10, 2) NULL, [JoiningDate]
DATETIME NULL,
[Department] NVARCHAR(20) NULL,
[Gender] VARCHAR(10) NULL)
--80. Write down
the query to create employee table with primary key (EmployeeID)
--ANS:
--ANS:
CREATE TABLE EmployeeDetail(
[EmployeeID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
[FirstName] NVARCHAR(50) NULL,[LastName] NVARCHAR(50) NULL, [Salary] DECIMAL(10, 2) NULL, [JoiningDate]
DATETIME NULL,
[Department] NVARCHAR(20) NULL,
[Gender] VARCHAR(10) NULL)
--81. How to set
Primary key using Alter command
--ANS:
--ANS:
ALTER TABLE EmployeeDetail ADD
PRIMARY KEY (P_EmployeeID)
--82. How to set
primary key and foreignkey relationship using query(set EmployeeID column of
ProjectDetail table as a foreignkey)
--ANS:
--ANS:
ALTER TABLE ProjectDetail
ADD CONSTRAINT fk_EmployeeDetailID_Eid FOREIGN KEY(EmployeeDetailID)REFERENCES EmployeeDetail(EmployeeID)
kindly send the pdf on my email id amit.aryan007@gmail.com
This is not for experienced developers .. Kindly upgrade the questions.
Yes,please update the questions
nice one
kindly send the pdf on my email id anand.pandit42@gmail.com
Hi Vikas,
This is very nice tutorials
Please send me pdf on this email id
ychittibabu123@gmail.ccom
Kindly send me SQL server and query related PDF on this mail I'd
Kalpesh.sojitra05@yahoo.com
Very useful sql collection .Please send the pdf to udsure33@gmail.com