SQL Server Interview Questions
Questions Answers Views Company eMail

what is the main difference between constraints(like primary key etc..)& joins?

2 5026

What are the types of model in sql server and explain

TCS,

2 5191

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 12755

What are the types of backup and tell me the difference between full and differential backup?

CTS, TCS,

4 11753

What is the difference between login and a user?

CTS, TCS,

13 26860

What is the use of placing primary key and foreign key constrains on columns.

Value Labs,

4 6674

what is IDE,DMV in sql server?

Value Labs,

1 7590

Wht is Stuff in sql ser

2 4183

how to get 25th row in any table in sqlserver can u tell me syntax

8 9627

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 10893

What is the default value of CHAR type?

Bosch,

10 18298

How to find the last update record in SQL Server?

4 15484

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

Value Labs,

7 9274

Can we create a clustered index on composite primary key.

IGT,

3 18009

what is hash table

ILFS, Teledata,

3 19274


Un-Answered Questions { SQL Server }

Differentiate between a primary key and a unique key.

522


What is model database in sql server?

507


What is bcnf normalization form?

599


What is the use of set nocount on/off statement?

562


Explain few examples of RDBMS?

540






What is the security principal at the server level that represents your session?

500


What are the functions in sql server?

480


How connect excel to sql server?

441


Can primary key be a foreign key?

494


What is statement level trigger?

477


Explain can SSRS reports Cache results?

106


What is similarity and difference between truncate and delete in sql?

524


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

488


What is bulkcopy in sql?

502


How to rebuild master databse?

588