SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?


3 7218

What are functions

3 5656

how to get the automatic backup of the database in the sql server

4 31162

What command do we use to rename a db?

5 7827

What are the four main query statements?


7 13873

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 11749

What is the STUFF function and how does it differ from the REPLACE function?

2 16399

What is SQL server agent?

HCL, SAP Labs,

2 5585

What is the purpose of UPDATE STATISTICS?

2 9276

What is de-normalization and when do you do it?

3 5056

Difference between Function and Stored Procedure?

C1 India,

9 14041

What is data integrity? Explain constraints?


1 21018

Explain some DBCC commands?

6 13236

What are tasks?


3 7634

What is the purpose of using COLLATE in a query?

1 15680

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


What is RMS migrations?


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A


sql database suspect We have a sql database that is showing as suspect. How can we recover?


How can we call UDF(User Define Function) using C# code in ASP.net ?


What are the dis_advantages of stored procedures, triggers, indexes?


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.


how to overcome kernel isssues


Tell about MOM Tool(Microsoft Operator Manager)?


System variable and temporary variables


how many no of arguments can be passed in procedures and functions


what exactly sql injuction.how to overcome.....


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


You are doing log shipping due to some reasons it is failing. How you will proceed from there