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 INTVAL( )and where we use Plz any body help me

1 5876

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

2061

What is the difference between a stored procedure and a user defined function in sql server?

Millennium,

2 7850

could u plz explain about joins and views?

2 5263

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 5331

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 6473

what is the sql equivaent of the dataset relation object ?

2027

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 24995

What is the difference between Drop and Truncate

GT Nexus, IBM,

20 37850

Anyone please explain me the concept of Serialization?

3 5424

What is transaction ? Give me one example.

Melstar, Wipro,

11 27807

UPDATE statement can on a single table or on the multiple table?

iGate, TCS,

7 14197

What is difference between TRUNCATE and DELETE statement

CTS,

12 23000

can any one please send sql quries most used in applications.

2 4550

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

Patni,

13 24386

Un-Answered Questions { SQL Server }

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1008

What is difference between inner join and join?

1044

Why the trigger fires multiple times in single login?

1211

Why use “pivot” in sql server?

1119

Is the order of columns in the set clause important in ms sql server?

968

Comment,Datatypes are unlimited

2057

How to use go command in "sqlcmd"?

1204

explain what is raid and what are different types of raid configurations? : Sql server database administration

1002

Explain the types of indexes.

1216

What is a document index?

1028

Explain the third normal form(3nf)?

943

Explain can you implement data mining in ssrs?

158

What is rank function?

1030

What do you mean by an execution plan? Why is it used?

1026

What are the reporting services components?

142

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