Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

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

 2 5608

What are the types of model in sql server and explain

TCS,

2 5732

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 13655

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

CTS, TCS,

4 12745

What is the difference between login and a user?

CTS, TCS,

13 28514

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

Value Labs,

4 7490

what is IDE,DMV in sql server?

Value Labs,

1 8081

Wht is Stuff in sql ser

 2 4747

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

 8 10842

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 11466

What is the default value of CHAR type?

Bosch,

10 19950

How to find the last update record in SQL Server?

 4 16266

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 10515

Can we create a clustered index on composite primary key.

IGT,

3 18752

what is hash table

ILFS, Teledata,

3 19890

Un-Answered Questions { SQL Server }

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

661

What is the difference between dbcc indexdefrag and dbcc reindex?

710

What is the difference between seek predicate and predicate?

763

You want to implement the one-to-one relationship while designing tables. How would you do it?

721

How do I view a trc file?

692

What is the meaning of sql server?

703

What is the use of group by clause?

715

What does nvl stand for?

719

Explain syntax for dropping triggers?

703

Define outer join in sql server joins?

682

What is the Difference Between Primary and Foreign Key?

761

What is the user of Primary key?

750

What are the dis_advantages of stored procedures, triggers, indexes?

1935

How many non clustered indexes there can be on table ?

680

Why I have to use stored procedures?

785

For More Un-Answered { SQL Server } Questions Click Here