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 6220

What are the types of model in sql server and explain

TCS,

2 6485

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 14842

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

CTS, TCS,

4 13789

What is the difference between login and a user?

CTS, TCS,

13 31492

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

Value Labs,

4 8488

what is IDE,DMV in sql server?

Value Labs,

1 8698

Wht is Stuff in sql ser

2 5362

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

8 12066

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 12051

What is the default value of CHAR type?

Bosch,

10 21565

How to find the last update record in SQL Server?

4 17119

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 11827

Can we create a clustered index on composite primary key.

IGT,

3 19611

what is hash table

ILFS, Teledata,

3 20560

Un-Answered Questions { SQL Server }

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1141

What is sql server schema compare? How we can compare two database schemas?

1030

What is report snapshot?

161

How to write a query with a right outer join in ms sql server?

913

Explain about protocol layer present in SQL server?

1200

How to find related tables in sql server?

944

What is a join in sql? What are the types of joins?

1105

What are the two modes of authentication in sql server?

1069

Where to find ntwdblib.dll version 2000.80.194.0?

962

what are constraints? Explain different types of constraints? : Sql server database administration

984

Which tcp/ip port does sql server run on? How can it be changed?

1039

What are the differences between decimal and float in ms sql server?

1243

Can we call stored procedure in view in sql server?

898

How to delete database objects with "drop" statements in ms sql server?

1089

How can I tell if sql server is 32 or 64 bit?

960

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