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 5961

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

2109

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

Millennium,

2 7969

could u plz explain about joins and views?

2 5360

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

3 5466

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

1 6545

what is the sql equivaent of the dataset relation object ?

2074

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 25421

What is the difference between Drop and Truncate

GT Nexus, IBM,

20 38508

Anyone please explain me the concept of Serialization?

3 5556

What is transaction ? Give me one example.

Melstar, Wipro,

11 28244

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

iGate, TCS,

7 14400

What is difference between TRUNCATE and DELETE statement

CTS,

12 23465

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

2 4681

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

Patni,

13 24860

Un-Answered Questions { SQL Server }

If the job running very slow what is the action you do

1946

What are the different types of collation sensitivity?

1182

What is a periodical index?

982

What are the differences between stored procedure and view in sql server?

1326

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1105

List out some of the requirements to set up a sql server failover cluster?

1083

How can you control the amount of free space in your index pages?

1108

What are different types of replication in sql server?

1149

Delete duplicate rows without using rowid.

1603

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2137

what's the information that can be stored inside a bit column? : Sql server database administration

1094

can any body tell me how to know the password of current user in sql server

2125

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1091

How to achieve Paging of records in SQL SERVER?

1151

what is the difference between delete table and truncate table commands? : Sql server database administration

1082

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