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 12871

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10788

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

2 4312

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

TVS,

2 5418

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

TCS,

5 8484

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 15463

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 13009

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 19755

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 12180

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 5380

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 5690

How reterive duplicate value in SQL?

6 10915

What is Transaction?

2 5903

Un-Answered Questions { SQL Server }

What is shrink log file?

956

Do comments need to go in a special place in sql server 2005?

921

What are the commands used in DCL?

1087

What is store procedure? How do they work?

1071

What is a data source file?

1024

how many triggers you can have on a table? : Sql server database administration

1023

Explain SSRS Architecture?

203

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

1027

Do you know what is a with(nolock)?

1109

How to test values returned by a subquery with the in operator?

1258

Are all views updatable ?

1205

What is the usage of the sign function?

1200

how you can configure a running aggregate in SSRS?

199

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2416

What is the current pricing model of SQL Azure?

104

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