SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 3826

What are the types of model in sql server and explain

TCS,

2 3831

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 10298




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

CTS, TCS,

4 9550

What is the difference between login and a user?

CTS, TCS,

13 20956

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

Value Labs,

4 4514

what is IDE,DMV in sql server?

Value Labs,

1 6208

Wht is Stuff in sql ser

2 2650




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

8 6949

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 9098

What is the default value of CHAR type?

Bosch,

10 14322

How to find the last update record in SQL Server?

4 13302

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 6029

Can we create a clustered index on composite primary key.

IGT,

3 13826

what is hash table

Teledata, ILFS,

3 16861


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

790


what is the sql equivaent of the dataset relation object ?

827


Delete duplicate rows without using rowid.

176


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

649


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

865






How do use Having,Group by,Group function in SQL?

662


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

843


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2639


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

799


how to overcome kernel isssues

459


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1254


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

703


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

837


How you trouble shoot when any job fails

674


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

348