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 12596

Can we call SP inside a query?

CA, CarrizalSoft Technologies, Wipro,

5 10581

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

2 4197

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

TVS,

2 5323

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

TCS,

5 8294

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 15290

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 12846

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 19090

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

3 6286

Explain Trigger with an example?

2 12080

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 5243

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

HCL,

1940

What is difference between Triggers and store procedure?

2 5554

How reterive duplicate value in SQL?

6 10674

What is Transaction?

2 5783

Un-Answered Questions { SQL Server }

What is attribute relationships, why we need it? : sql server analysis services, ssas

961

Why it is recommended to avoid referencing a floating point column in the where clause?

958

What is standby servers? Explain types of standby servers.

993

What is the order by used for?

1017

What is difference between group by and having?

943

Do you know what are pages and extents? : SQL Server Architecture

991

Explain how to maintain a fill factor in existing indexes?

991

What do you do in data exploration

984

What are drillthrough reports?

155

How to create a user name in a database?

1049

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1144

Explain user defined views?

957

What is after dml trigger?

1010

Explain important index characteristics?

1026

What are the advantages of stored procedure in sql server?

890

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