SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

write the query for find the top 2 highest salary in sql server

Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

36 75295

how to retrive only second row from table in sql server 2000?

Cognizant, CTS,

15 27082

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

tdfc, vsworx,

9 12266

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 6821

Alternative way to DetDate() function?

5 10016

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

Oracle, Scend, TechInfini,

35 61371

How to delete an attribute from the emp table

4 9711

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 4638

How we create SQL Server 2005 Reporting Services ? Give me Sample

HCL,

2051

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

Infosys, TCS,

18 69012

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

Idea,

1 8941

how to find out the repeated value from table using groupby function?

4 7469

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

ABC, TCS,

5981

What is mean by "fill factor" ? and what is mean by "Index "in sql?

iGate, Logica CMG,

1 9454

write the query for taking database backup in sql

ABC, IBM, Logica CMG, MA,

10 37187

Un-Answered Questions { SQL Server }

How to drop an existing schema in ms sql server?

1153

What is the default order of an order by clause?

1041

How do I setup a local sql server database?

1074

What is instead of trigger sql server?

1085

How to check table values in sql server?

1012

How to generate create view script on an existing view?

1045

What are constraints?

1064

what is difference between NULL and ISNULL in SQL Server 2008?

1060

Can a unique index be created on a column, which contains null?

972

What are different types of database indexes?

1175

What is a non clustered primary key?

978

You want to use a perspective in an mdx query. How do you select the perspective?

246

What is sql server locking?

1036

Can we install sql server 2016 on windows 7?

1201

What is the importance of three tier architecture?

1150

For More Un-Answered { SQL Server } Questions Click Here