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 difference between OLEDB and ODBC

CFCI,

4 12893

What are mdf,ndf,ldf files and how to see the data in those files?

Accenture,

6 60468

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

Value Labs,

2557

What is the difference between DTS and SSIS?

Allianz,

3 37709

How to Debug a Stored Procedure?

Allianz,

5 14455

How to link up the text file to a Database table?

Allianz,

2 6549

Which institute is best for SQL Server 2005 Training?

6 7602

What is user stored procedure & it purpose?

Wipro,

4 8575

How do we rollback the table data in SQL Server

3 17155

where do you use Isolations?give me some exmpale?

1 5335

In which year relase the 7.0& 2000 & 2005?

1 3853

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

Covansys,

1 6272

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 7922

select empid empname from employee What is the result for the about query?

4 7887

can you any body tell me suppose database is suspect mode. how can take to normal?

Teledata,

2 6399

Un-Answered Questions { SQL Server }

what's the difference between a primary key and a unique key? : Sql server database administration

991

Why we should not use triggers?

1016

How do I start sql server?

1030

What is meant by indexing files?

1103

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1355

How many full-text indexes can a table have?

1026

Differentiate between sql temp table vs table variable?

929

how to do partition in sqlserver

2547

Explain logical operators in sql server?

1185

How to skip remaining statements in a loop block using continue statements?

1045

What is exporting and importing utility?

1150

How to get all stored procedures in sql server?

1067

What are security principals used in sql server 2005?

1041

your distribution database is full what will u do

2224

Which language rdl files made of?

141

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