SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 5605

What are the types of model in sql server and explain

TCS,

2 5728

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 13645

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

CTS, TCS,

4 12737

What is the difference between login and a user?

CTS, TCS,

13 28493

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

Value Labs,

4 7480

what is IDE,DMV in sql server?

Value Labs,

1 8077

Wht is Stuff in sql ser

2 4739

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

8 10829

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 11460

What is the default value of CHAR type?

Bosch,

10 19941

How to find the last update record in SQL Server?

4 16261

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 10514

Can we create a clustered index on composite primary key.

IGT,

3 18746

what is hash table

ILFS, Teledata,

3 19887


Un-Answered Questions { SQL Server }

Why Master database is required?

763


What are the recovery models for a database?

817


How do I debug a stored procedure in sql server?

732


What is a partitioned view?

772


How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

770


How to insert and update data into a table with "insert" and "update" statements?

705


What are the difference between “where” and “having” clause in sql server?

755


What are the differences between having and where clause.

715


What are the new features of sql server 2012 reporting service?

101


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

923


What is order of B+tree?

861


Explain what is scheduled job and how to create it?

723


What is attribute relationships, why we need it? : sql server analysis services, ssas

678


What is rs.exe utility?

138


How to see existing views in ms sql server?

728