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 5355

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

2 19914

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

CarrizalSoft Technologies, HCL,

10 14769

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

1 20061

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 6023

what is a cursor and what is its use?

L&T,

2 8698

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

7 10055

what is trigger

CarrizalSoft Technologies, NIIT,

1 4958

what is difference between nchar and char in Sql server ?

3 8324

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

3 6599

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 8214

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

CarrizalSoft Technologies, Sonata,

7 11487

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 4541

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 4234

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

8 13482

Un-Answered Questions { SQL Server }

Explain about system database?

1110

What are the restrictions while creating batches in sql server?

1122

What are out-of-range errors with date and time literals?

1099

What do you understand by replication in sql server? Mention the different types of replication in sql server.

994

What do you mean by collation recursive stored procedure?

1112

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1189

Write a query to find 5th highest amount paid from the customer table.

994

What are pages and extents? : SQL Server Architecture

1077

What are the differences between stored procedure and the dynamic sql?

1141

What is cached report?

150

Explain foreign key in sql server?

1075

What are scalar functions in sql?

1211

How does using a separate hard drive for several database objects improves performance right away?

990

How does stuff differ from the replace function?

1064

Why do we use non clustered index?

1135

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