SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 7692

What are functions

3 6024

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

4 31410




What command do we use to rename a db?

5 8101

What are the four main query statements?

Wipro,

7 14364

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

3 11940

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

2 16728

What is SQL server agent?

HCL, SAP Labs,

2 5853




What is the purpose of UPDATE STATISTICS?

2 9618

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

3 5250

Difference between Function and Stored Procedure?

C1 India,

9 14384

What is data integrity? Explain constraints?

Thinksoft,

1 21449

Explain some DBCC commands?

6 13615

What are tasks?

Wipro,

3 7921

What is the purpose of using COLLATE in a query?

1 15937


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

835


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1059


What is RMS migrations?

970


whats the maximum size of view state??

965


what is the Ticketing tool used in Wipro technologies at Bangalore...???

5088






What is the difference between NOROW and LOCKROW?

1318


If user is owning any SQL Objects, can we drop that user

863


how to take backup bcp out for a column in table in sql server?

867


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

724


how can u get last observation in an unknown dataset ?

1169


whats new about truncate in sql server 2008?

1326


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1122


System variable and temporary variables

994


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

3520


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.

716