SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

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?

Wipro,

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?

Thinksoft,

1 21018

Explain some DBCC commands?

6 13236

What are tasks?

Wipro,

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?

834


What is RMS migrations?

903


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

319


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

672


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

4583






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

904


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?

1196


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.

658


how to overcome kernel isssues

437


Tell about MOM Tool(Microsoft Operator Manager)?

634


System variable and temporary variables

931


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

3422


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

1265


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

1253


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

772