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

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 5250

what is the main difference between after trigger and instead trigger.

2 19814

I have to display ten columns values from diffrent ten tables. how many joins are require?

CarrizalSoft Technologies, HCL,

10 14454

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 19935

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 5925

what is a cursor and what is its use?

L&T,

2 8553

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 9796

what is trigger

CarrizalSoft Technologies, NIIT,

1 4853

what is difference between nchar and char in Sql server ?

3 8167

How can we write or define DDL statements in Sql server and DML statements?

3 6490

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 7954

write down the code for "how we delete a table without using of Drop command " ?

CarrizalSoft Technologies, Sonata,

7 11247

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 4428

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 4158

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 13228

Un-Answered Questions { SQL Server }

What is sql server transaction log file?

1049

What are a scheduled jobs or what is a scheduled tasks?

899

What is t-sql script to take database offline – take database online.

1079

What is a coalesce function?

1189

How to create median function?

164

Difference between drill down and drill through report.

948

Explain the rules for designing files and file groups in sql server?

984

What is report server project?

147

How to update muliple row in single query?

1053

What is the process of normalization?

1119

Describe how to use linked server?

1010

Ms sql server index?

1060

What structure can you implement for the database to speed up table reads?

1194

When to use Inner join & when to use subquery?

1155

Define full outer join?

950

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