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 10351

What is a join and their types?

Challenger Financial,

2 7547

What is the difference between referencing and joining?

1 4130

What is the difference between constraints and triggers?

Wipro,

9 36599

What is ACID Property of Transaction?

10 37921

What is an index?

Yardi Software,

8 15404

What is normalization and its forms?

Challenger Financial,

4 14313

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

8 19246

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

11 54294

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

3 6713

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 25479

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

13 52858

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

College School Exams Tests, HCL, Infosys, TCS,

25 112952

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 6665

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

2 11356

Un-Answered Questions { SQL Server }

Where do we use trace frag?

1015

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

1068

What do you do in data exploration

993

What are the types of user defined functions in sql server?

1049

How many types of database relationship in sql server?

1054

How do I install only the client tools of sql server 2000?

1067

What is the maximum size of column in sql server?

893

What are the different types of locks in the database?

925

Which is the main third-party tool used in sql server?

942

What is normalization of database?

1105

What are cascading parameters in ssrs reports?

230

Why use sub query in sql server and list out types of sub queries?

1000

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1101

How do I create a trace in sql server?

1041

Write SQL queries on Self Join and Inner Join.

1154

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