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 5389

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

2 19939

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

CarrizalSoft Technologies, HCL,

10 14848

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

1 20084

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 6043

what is a cursor and what is its use?

L&T,

2 8722

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

7 10134

what is trigger

CarrizalSoft Technologies, NIIT,

1 4970

what is difference between nchar and char in Sql server ?

3 8380

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

3 6629

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 8308

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

CarrizalSoft Technologies, Sonata,

7 11535

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 4564

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 4258

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

8 13563

Un-Answered Questions { SQL Server }

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1120

Why should you use or avoid select * statements?

1097

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1183

How can I check that whether automatic statistic update is enabled or not?

1106

List the ways in which dynamic sql can be executed?

1074

What is a view in sql?

1035

What is clustered index

1079

What is acid mean in sql server?

1227

What are the different types of subquery?

1224

How raid can influence database performance?

1102

How to remove duplicate rows from table except one?

1076

Can we do dml on views?

1027

Can we shrink data file in sql server?

1116

What are the different subsets of sql?

1638

what is spatial nonclustered index

1050

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