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 5354

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

2 19907

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

CarrizalSoft Technologies, HCL,

10 14751

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

1 20055

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 6020

what is a cursor and what is its use?

L&T,

2 8695

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

7 10049

what is trigger

CarrizalSoft Technologies, NIIT,

1 4955

what is difference between nchar and char in Sql server ?

3 8320

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

3 6595

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 8208

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

CarrizalSoft Technologies, Sonata,

7 11484

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 4535

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 4233

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 }

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1124

How can sql server instances be hidden? : sql server security

1218

Which trace flags are enabled in sql server?

1076

How to find the login name linked to a given user name?

1062

What is the use of for clause?

1166

How can you list all the columns in a database?

972

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1041

What is the maximum number of index per table?

1120

What is de-normalization and what are some of the examples of it?

1019

What are sql servers used for?

1114

What is a deadlock and what is a live lock?

1041

What are four major operators that can be used to combine conditions on a where clause?

1090

Tell me the phases a transaction has to undergo?

1019

What is the difference between function and stored procedure in sql server?

1155

What are dml (data manipulation language) statements in ms sql server?

1027

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