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 5158

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

2 19727

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

CarrizalSoft Technologies, HCL,

10 14199

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

1 19849

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 5852

what is a cursor and what is its use?

L&T,

2 8457

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

7 9620

what is trigger

CarrizalSoft Technologies, NIIT,

1 4761

what is difference between nchar and char in Sql server ?

3 8024

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

3 6382

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 7716

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

CarrizalSoft Technologies, Sonata,

7 11029

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 4327

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 4109

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

8 13007

Un-Answered Questions { SQL Server }

Where do we use trace frag?

977

What are .mdf files?

893

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

997

Which are the third-party tools used in sql server and why would you use them?

858

How does recursive cte works in sql server?

951

State the difference between union and union all?

895

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2033

What does the not null constraint do?

1016

What do you mean by data manipulation language?

956

Which tcl commands are available on the sql server?

1026

Can we write ddl in trigger?

872

Explain the relational database management system (rdbms)?

1036

What is the osql utility?

923

What the different components of Replication and what is their use?

1028

What are the types of normalization?

975

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