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 5263

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

2 19825

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

CarrizalSoft Technologies, HCL,

10 14473

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

1 19941

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 5928

what is a cursor and what is its use?

L&T,

2 8570

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

7 9825

what is trigger

CarrizalSoft Technologies, NIIT,

1 4857

what is difference between nchar and char in Sql server ?

3 8178

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

3 6495

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 7983

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

CarrizalSoft Technologies, Sonata,

7 11270

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 4434

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 4168

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

8 13266

Un-Answered Questions { SQL Server }

When would you use it?

994

Explain tablesample?

999

Is the primary key column of a table an index in ms sql server?

962

what is a sub-report?

140

Can we insert data into view sql server?

927

What is the usage of the sign function?

1114

How can you stop stored procedures from recompiling?

900

What is an execution plan? When would you use it?

978

what is normalization? Explain different levels of normalization? : Sql server database administration

1326

What is a full text index?

922

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

978

What is the sql case statement used for?

1098

Can group by and orderby be used together?

1013

What is microsoft sql server?

974

Mention the 3 ways to get a count of the number of records in a table.

978

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