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 3883

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

CGI,

2 5988

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

Cap Gemini,

2065

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

ADP, iSoft,

2477

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 14226

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

1 3696

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 3784

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 8757

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

3 7278

what are the main differences between ms access and sqlserver

C DAC, CDAC,

1 4879

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 5647

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

3 4933

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

2 7436

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 8351

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 21385

Un-Answered Questions { SQL Server }

Can we add a cpu to sql server?

1003

How to delete all rows with truncate table statement in ms sql server?

997

Which table keeps the locking information?

915

Is a primary key unique?

987

Is it important for a database administrator to understand the operating system and file access?

975

Explain the different types of backups available in sql server? : sql server database administration

917

what are database files and filegroups? : Sql server database administration

941

What is difference between table aliases and column aliases? Do they affect performance?

959

What is right outer join in sql server joins?

1178

what is a correlated sub-query? : Sql server database administration

937

How to list all tables in the database using odbc_tables()?

1042

What are the joins in sql server? : sql server database administration

998

What are different types of schemas?

940

If a table does not have a unique index, can a cursor be opened on it?

911

What are the advantages dts has over bcp?

997

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