SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?


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?


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?


1 21449

Explain some DBCC commands?

6 13615

What are tasks?


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


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


What is RMS migrations?


whats the maximum size of view state??


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


What is the difference between NOROW and LOCKROW?


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


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


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


how can u get last observation in an unknown dataset ?


whats new about truncate in sql server 2008?


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


System variable and temporary variables


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


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.