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 9612

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 9221

HOW TO RENAME A COLUMN NAME

3 7437

what is cluster and nin-cluster index?

4 7097

how to delete duplicate rows from table in sql server

HCL, UHG,

12 23661

What is difference beteen Migration and Upgrdation?

Satyam,

7 25339

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

4 27583

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

3 31851

What is row by row processing ?

2 8639

can primery key be a non clustered index?

10 13586

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

1 5593

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 9993

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

Wipro,

4 10417

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

8 10766

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

1 3855

Un-Answered Questions { SQL Server }

How do you implement session management in SQL Server mode?

1160

Why is sql server log file full?

1082

What is the purpose of the model database?

1071

Can we deploy SSRS reports on our personal website?

176

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

1139

Explain try...catch with sql server?

1072

what types of replication are supported in sql server? : Sql server database administration

1135

What is a transact-sql statement?

1131

How can sql injection be stopped? : sql server security

1107

System variable and temporary variables

2302

How to use subqueries in the from clause in ms sql server?

1212

What is an example of a foreign key?

1033

What is compound operators?

1120

What are the differences between left join and inner join in sql server?

1157

What is the data tier application?

169

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