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 5863

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

2057

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

Millennium,

2 7845

could u plz explain about joins and views?

2 5257

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

3 5316

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

1 6466

what is the sql equivaent of the dataset relation object ?

2017

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 24949

What is the difference between Drop and Truncate

GT Nexus, IBM,

20 37775

Anyone please explain me the concept of Serialization?

3 5413

What is transaction ? Give me one example.

Melstar, Wipro,

11 27770

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

iGate, TCS,

7 14157

What is difference between TRUNCATE and DELETE statement

CTS,

12 22935

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

2 4532

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

Patni,

13 24306

Un-Answered Questions { SQL Server }

How to scale out a federation by Sql statement?

116

Can group by be used without aggregate functions?

914

How to see existing views in ms sql server?

1041

What is a db view?

891

What is difference between inner join and join?

1036

What is the New in SQL server 2008?

966

Can we join two tables without primary key?

1042

What is @@rowcount in sql?

1001

What is the difference between executequery () and executeupdate ()?

1025

Is INSTEAD OF trigger directly applicable to Table ?

1009

How to send email from database?

1011

What is the difference between deallocate cursor and close cursor?

1248

What is acid properties?

1085

What are different types of subquery?

1235

Can truncate be rolled back?

933

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