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 6103

What are the types of model in sql server and explain

TCS,

2 6340

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 14640

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

CTS, TCS,

4 13603

What is the difference between login and a user?

CTS, TCS,

13 30886

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

Value Labs,

4 8322

what is IDE,DMV in sql server?

Value Labs,

1 8576

Wht is Stuff in sql ser

2 5263

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

8 11783

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 11910

What is the default value of CHAR type?

Bosch,

10 21209

How to find the last update record in SQL Server?

4 16959

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 11546

Can we create a clustered index on composite primary key.

IGT,

3 19429

what is hash table

ILFS, Teledata,

3 20435

Un-Answered Questions { SQL Server }

What is an identity?

943

What to perform pattern match with the like operator?

848

Explain about extended stored procedure?

876

Explain what is log shipping?

1079

what is checksum in sql server.........???

1634

How to make remote connection in database?

967

what is memory-optimized nonclustered indexes

969

How to add the custom code in Report?

120

How to modify an existing stored procedure in ms sql server?

1024

where the connection string store in the database

2028

How many tables can be joined in SQL Server?

1017

How to create database with physical files specified in ms sql server?

960

What are the new security features added in sql server 2012? : sql server security

960

Explain user defined functions?

950

What are distinctive joins find as a part of sql?

917

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