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

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

TCS,

8 12869

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10786

Can some one please help with a query which will take only max value of a column in a join.

2 4306

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

TVS,

2 5413

which database is best to use in oracle and sql server? explain reasons?

TCS,

5 8482

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 15461

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

CarrizalSoft Technologies, iGate,

3 13006

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

3i Infotech, Rolta, TCS,

17 19725

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 6399

Explain Trigger with an example?

2 12178

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 5373

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

HCL,

2001

What is difference between Triggers and store procedure?

2 5686

How reterive duplicate value in SQL?

6 10910

What is Transaction?

2 5898

Un-Answered Questions { SQL Server }

What is normalization? Describe its different types.

1157

What is unpivot?

1077

What is the purpose of optimization?

1061

How to define the name and server for a new dsn?

1197

What does REVERT do in SQL Server 2005?

1013

How to modify an existing user defined function?

1172

How to generate create view script on an existing view?

1045

Explain what is raid and what are different types of raid levels?

1094

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1025

What are the instances when triggers are appropriate?

1020

What do you understand by a view? What does the with check option clause for a view do?

1061

Can two different columns be merged into single column? Show practically?

1124

What is the name of the Database which IBM mainframe uses?

1033

Is sql server is free?

1017

How do you manipulate data?

949

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