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 5262

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

2 19822

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

CarrizalSoft Technologies, HCL,

10 14471

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

1 19940

What is Peer to peer Replication?

CarrizalSoft Technologies, HCL,

1 5928

what is a cursor and what is its use?

L&T,

2 8568

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

7 9824

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 7979

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

CarrizalSoft Technologies, Sonata,

7 11263

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 4431

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 13265

Un-Answered Questions { SQL Server }

What is a DBMS, query, SQL?

1046

What is standby servers? Explain types of standby servers.

995

How to perform key word search in tables?

961

Explain system functions or built-in functions? What are different types of system functions?

979

What is dml command?

966

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2071

How do I start sql server 2016?

908

What are the underflow and overflow behaviors on float literals?

1113

Who is the owner of a schema in ms sql server?

1077

Which language is supported by sql server?

1013

What are the types of sql server?

1051

Explain transaction isolation levels in sql server?

1114

How to create new tables with "create table" statements in ms sql server?

1066

What is bulkcopy in sql?

943

What do you need to connect php to sql server?

1104

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