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

what are the limitations of parameters in a storedprocedure

1 3963

Which index created when Create Index on table(col), Why

CGI,

2 6100

last function used in MS Access to convert sql what function will use in sql

Cap Gemini,

2114

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

ADP, iSoft,

2545

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

Google, TCS, Unisys,

7 14484

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 3777

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 3883

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 8957

How to delete the duplicate rows from a table in SQL Server ??

3 7398

what are the main differences between ms access and sqlserver

C DAC, CDAC,

1 4958

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 5769

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 5077

what is integrated security (SSPI). why we use in the connection string?

2 7536

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

Microsoft, TCS, Techastrum,

3 8472

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

Adsys, Cap Gemini,

15 21848

Un-Answered Questions { SQL Server }

What is lock escalation and what is its purpose?

1024

Explain sql server authentication modes?

1185

What languages bi uses to achieve the goal?

1050

can we have a nested transaction? : Sql server database administration

1188

How to declare and use cursor variables?

1250

What is bcnf normalization form?

1158

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

157

What is join and name different type of joins?

1097

What does it mean if @@cursor_row returns a negative number?

1034

Explain various On-Delete options in a DB table. Which is the default option?

1531

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

952

What is data source object?

1064

Explain the steps to use transact-sql cursor?

1154

what are the different types of SSRS reports?

160

How to create an index on an existing table in ms sql server?

1025

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