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

Why we need a group by clause?

4 10516

What is a join and their types?

Challenger Financial,

2 7695

What is the difference between referencing and joining?

1 4231

What is the difference between constraints and triggers?

Wipro,

9 36937

What is ACID Property of Transaction?

10 38206

What is an index?

Yardi Software,

8 15706

What is normalization and its forms?

Challenger Financial,

4 14513

What is a cursor in SQL Server 2000 and their types?

8 19533

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 54706

How do we return a record set from a Stored Procedure in SQl server 2000?

3 6854

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 25759

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 53209

What are the differences between stored procedure and functions in SQL Server 2000?

College School Exams Tests, HCL, Infosys, TCS,

25 113818

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 6789

Which is best Subquery (or) joins in sql server? explain why

2 11442

Un-Answered Questions { SQL Server }

How to insert and update data into a table with "insert" and "update" statements?

1053

Would you store your query in a ssrs report or a database server? State the reason why?

157

If the job running very slow what is the action you do

1946

How to download and install the scaled-down database adventureworkslt?

1046

Why I can not enter 0.001 second in date and time literals in ms sql server?

1117

What are the advantages of using third-party tools?

1044

What is the purpose of forms?

1010

What is default constraint?

1056

What is difference between createstatement and preparedstatement?

1179

What is cdc in sql server?

1046

How to implement service broker?

1076

do views contain data ?

1025

What is raiseerror? What is raiseerror?

1197

What is meant by indexing files?

1103

What is table value parameters (tvp)?

1154

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