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 10333

What is a join and their types?

Challenger Financial,

2 7530

What is the difference between referencing and joining?

1 4122

What is the difference between constraints and triggers?

Wipro,

9 36553

What is ACID Property of Transaction?

10 37894

What is an index?

Yardi Software,

8 15355

What is normalization and its forms?

Challenger Financial,

4 14294

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

8 19202

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

11 54244

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

3 6702

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 25439

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

13 52802

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

College School Exams Tests, HCL, Infosys, TCS,

25 112850

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 6645

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

2 11342

Un-Answered Questions { SQL Server }

What is transaction server explicit transaction?

1027

How will you make an attribute not process? : sql server analysis services, ssas

1077

Difference between Inner vs outer joins?

943

What are scheduled tasks in sql server?

1074

Explain few of the new features of sql server 2008 management studio

907

How to delete a database in ms sql server?

1220

What are ddl triggers and types of ddl trigger?

1033

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1007

Explain in brief about Microsoft SQL server?

1085

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

1885

What is the purpose of optimization?

987

Explain logical operators in sql server?

1101

What is repeatable read?

1006

How to remove duplicate rows from table except one?

1000

What are number line correlation administrators will use while working with a subquery?

1167

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