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 12614

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10590

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

2 4212

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

TVS,

2 5330

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

TCS,

5 8301

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 15303

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 12858

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 19149

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

3 6289

Explain Trigger with an example?

2 12084

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 5254

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

HCL,

1942

What is difference between Triggers and store procedure?

2 5556

How reterive duplicate value in SQL?

6 10699

What is Transaction?

2 5789

Un-Answered Questions { SQL Server }

What is the difference between upgrade and migration in sql server?

1090

How to create prepared statements using odbc_prepare()?

1065

What are the grouping functions?

933

What are sql server procedures?

979

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1750

What are the requirements on sql server network connections?

993

What are logical/boolean operations in ms sql server?

1040

What the difference between UNION and UNIONALL?

1040

Can a database be shrunk with users active?

1133

What is the command used to recompile the stored procedure at run time?

1081

How are the unique and primary key constraints different?

1075

Explain nested join?

983

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1013

Why use cursor in sql server?

1077

What is self contained multi valued query?

1015

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