SQL Server Interview Questions
Questions Answers Views Company eMail

What is INTVAL( )and where we use Plz any body help me

1 5140

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

1563

What is the difference between a stored procedure and a user defined function in sql server?

Millennium,

2 6761

could u plz explain about joins and views?

2 3898

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 4295

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 5563

what is the sql equivaent of the dataset relation object ?

1561

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 21441

What is the difference between Drop and Truncate

GT Nexus, IBM,

20 31948

Anyone please explain me the concept of Serialization?

3 4271

What is transaction ? Give me one example.

Melstar, Wipro,

11 24504

UPDATE statement can on a single table or on the multiple table?

iGate, TCS,

7 11715

What is difference between TRUNCATE and DELETE statement

CTS,

12 18886

can any one please send sql quries most used in applications.

2 3502

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

Patni,

13 20576


Un-Answered Questions { SQL Server }

What is the use of “join” in sql server?

559


What are different types of views?

545


Explain what stored procedure sp_replcounters is used for? : sql server replication

991


If a table does not have a unique index, can a cursor be opened on it?

510


What is partition index in sql server?

602






While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

546


How display code or Text of Stored Procedure using Sql query in Sql Server ?

598


Can we add an identity column to decimal datatype?

572


How to delete duplicate rows from table except one?

539


What is extended stored procedures?

553


how you can list all the tables in a database?

518


Explain trigger and its types?

604


What is it’s similarity with sql server?

143


Does the unique constraint create an index?

555


How to transfer data from a cursor to variables with a "fetch" statement?

575