Side Gadgets

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:
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:
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:
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:
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:
ALTER TABLE ProjectDetail
ADD CONSTRAINT fk_EmployeeDetailID_Eid FOREIGN KEY(EmployeeDetailID)REFERENCES EmployeeDetail(EmployeeID)
CLICK HERE FOR ALL SQL INTERVIEW QUESTIONS/QUERY SET (MORE THAN 500)
 
8 comments
Share
Labels, ,

Comments

  1. aryan_world22 November 2014 at 23:01

    kindly send the pdf on my email id amit.aryan007@gmail.com

    ReplyDelete
  2. Unknown15 January 2015 at 02:51

    This is not for experienced developers .. Kindly upgrade the questions.

    ReplyDelete
  3. Anonymous28 April 2015 at 23:57

    Yes,please update the questions

    ReplyDelete
  4. srs211 August 2016 at 13:25

    nice one

    ReplyDelete
  5. Anand Upadhyay27 September 2016 at 09:15

    kindly send the pdf on my email id anand.pandit42@gmail.com

    ReplyDelete
  6. Unknown12 October 2016 at 08:18

    Hi Vikas,
    This is very nice tutorials
    Please send me pdf on this email id
    ychittibabu123@gmail.ccom

    ReplyDelete
  7. Unknown24 January 2017 at 10:05

    Kindly send me SQL server and query related PDF on this mail I'd
    Kalpesh.sojitra05@yahoo.com

    ReplyDelete
  8. Unknown15 April 2020 at 23:36

    Very useful sql collection .Please send the pdf to udsure33@gmail.com

    ReplyDelete

Contact Form

Send