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 disadvantage of SQL Loder?

1 7013

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

TCS,

7 12308

what is difference between Enterprise Manager and Query Analyer

CTS,

6 9780

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

Synergy,

1 6418

what is DTS what are tasks available

Wipro,

1 3901

Normalization and denormalization

Wipro,

3 6943

Diffrent types of function

Wipro,

1 4511

diffrence between function and procedure

Wipro,

5 7588

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6335

System variable and temporary variables

Wipro,

2299

optimization techinques

Wipro,

2718

user defined datatypes

Wipro,

1 4564

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1956

Magic Tables ?

Thomson Reuters,

2 6480

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 5149

Un-Answered Questions { SQL Server }

Is sql server a database?

1040

Difference between LEN() and DATALENGTH() in sql server ?

1171

Why we use functions in sql server?

1130

What is the xml datatype?

1122

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1199

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

Explain multiserver query

1113

Explain about merge replications?

1078

What different steps will a sql server developer take to secure sql server?

1039

Explain how many types of relationship?

1085

How to download and install microsoft sql server management studio express?

1092

How to delete duplicate rows?

1037

Explain differentiate between a having clause and a where clause?

949

Is there any difference between primary key and unique with the not null condition?

1001

How you can change a cross join into an inner join?

1022

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