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 4537

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

1119

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

Millennium,

2 5804

could u plz explain about joins and views?

2 3039

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

3 3343

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

1 4990

what is the sql equivaent of the dataset relation object ?

1094

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 18304

What is the difference between Drop and Truncate

GT Nexus, IBM,

20 26956

Anyone please explain me the concept of Serialization?

3 3218

What is transaction ? Give me one example.

Melstar, Wipro,

11 21153

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

iGate, TCS,

7 9289

What is difference between TRUNCATE and DELETE statement

CTS,

12 15708

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

2 2613

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

Patni,

13 13686

Un-Answered Questions { SQL Server }

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

140

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

124

How dts is used to extract, transform and consolidate data?

145

What is a filestream?

139

Explain the different types of joins?

126

Why SQL Agent is used?

175

Why do we need normalization?

109

How to choose all records from the table?

186

What is the difference between stored procedure and functions?

172

How to maintain a fill factor in existing indexes?

129

What are the rules to use the rowguidcol property to define a globally unique identifier column?

150

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

138

What is the difference between ddl and dml?

110

What is bulkcopy in sql?

141

How many types of stored procedures are there in sql server?

126

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