SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

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

2 6199

What are the types of model in sql server and explain

TCS,

2 6473

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 14825

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

CTS, TCS,

4 13771

What is the difference between login and a user?

CTS, TCS,

13 31432

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

Value Labs,

4 8467

what is IDE,DMV in sql server?

Value Labs,

1 8687

Wht is Stuff in sql ser

2 5352

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

8 12041

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 12020

What is the default value of CHAR type?

Bosch,

10 21517

How to find the last update record in SQL Server?

4 17105

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 11793

Can we create a clustered index on composite primary key.

IGT,

3 19598

what is hash table

ILFS, Teledata,

3 20546

Un-Answered Questions { SQL Server }

What does it mean to be in union?

931

Which are the olap features?

951

How to create a scrollable cursor with the scroll option?

993

Explain different types of collation sensitivity?

975

What stored by the model?

1047

Can you explain full-text query in sql server?

1007

What is report snapshot in ssrs?

266

What is simple indexing method?

1016

Where cross join is used?

951

What are functions in the sql server?

1206

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1056

How to loop through result set objects using mssql_fetch_array()?

1069

Does a server store data?

920

What is default constraint in ms sql server?

1024

What is the fillfactor concept in indexes?

974

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