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 12697

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

Accenture,

6 60192

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

Value Labs,

2498

What is the difference between DTS and SSIS?

Allianz,

3 37498

How to Debug a Stored Procedure?

Allianz,

5 14194

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

Allianz,

2 6420

Which institute is best for SQL Server 2005 Training?

6 7385

What is user stored procedure & it purpose?

Wipro,

4 8387

How do we rollback the table data in SQL Server

3 16962

where do you use Isolations?give me some exmpale?

1 5246

In which year relase the 7.0& 2000 & 2005?

1 3750

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 6189

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 7729

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

4 7689

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

Teledata,

2 6290

Un-Answered Questions { SQL Server }

How to select some specific rows from a table in ms sql server?

1002

Do you know the policy based administration feature of sql server 2008?

950

How to use "begin ... End" statement structures in ms sql server?

1033

What is ms sql server reporting services?

1047

write an SQL query to list the employees who joined in the month of January?

1674

What is the difference between implicit and explicit transaction?

1006

What are the approximate numeric data types?

923

What is a recursive stored procedure in sql server?

1167

How do you implement session management in SQL Server mode?

1095

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1057

Do I need a report server to run reports in my application?

165

Explain the usage of floor function in sql server.

959

How to Sync Two SQL Azure Databases?

121

What is field with example?

914

What to check if a User database is locked?

1060

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