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 is difference between primary key and Unique

8 9382

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

SAP Labs,

3 9086

HOW TO RENAME A COLUMN NAME

3 7313

what is cluster and nin-cluster index?

4 6929

how to delete duplicate rows from table in sql server

HCL, UHG,

12 23288

What is difference beteen Migration and Upgrdation?

Satyam,

7 25082

What are different types of Keys? Please explain all the keys with a suitable example.

4 27400

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 31674

What is row by row processing ?

2 8552

can primery key be a non clustered index?

10 13304

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 5527

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 9788

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

Wipro,

4 10210

How to find out name of all employees who has salary less than 200 Rs.?

8 10545

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 3760

Un-Answered Questions { SQL Server }

Can we use custom code in ssrs?

1115

Write a code to select distinct records without using the DISTINCT keyword.

1114

what is unique and xaml nonclustered index

1051

What is the difference between drop table and truncate table?

924

What are the main differences between #temp tables and @table variables and which one is preferred?

1083

How to select all columns of all rows from a table with a select statement in ms sql server?

1114

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1396

Can I save my report as html, excel or word? : sql server management studio

955

What is the difference between an index and a unique index?

1001

What are the different methods available under sqlcommand class to access the data?

1121

What is compound operators?

1058

What is table-valued sub query?

967

How to create dbo table in sql server?

951

Can we add our custom code in ssis?

988

What are the database objects? : SQL Server Architecture

1048

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