Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between OLEDB and ODBC

CFCI,

4 9537

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

Accenture,

6 55876

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

Value Labs,

1680

What is the difference between DTS and SSIS?

Allianz,

3 34656

How to Debug a Stored Procedure?

Allianz,

5 9926

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

Allianz,

2 4361

Which institute is best for SQL Server 2005 Training?

6 4144

What is user stored procedure & it purpose?

Wipro,

4 5635

How do we rollback the table data in SQL Server

3 14710

where do you use Isolations?give me some exmpale?

1 3849

In which year relase the 7.0& 2000 & 2005?

1 2476

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 4711

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 5338

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

4 4606

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

Teledata,

2 4639







Un-Answered Questions { SQL Server }

How are the exceptions handled in sql server programming?

208


How do I debug a stored procedure in sql server?

176


What is the difference between a local and a global temporary table?

238


What is sub-query in sql server? Explain its properties.

197


You want to implement the many-to-many relationship while designing tables. How would you do it?

197






Explain user defined functions?

216


what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

209


Where views are stored in sql server?

176


How many tables can be joined in SQL Server?

224


Can sql servers link to other servers like oracle?

173


How to create a scrollable cursor with the scroll option?

182


Explain aggregate functions?

204


What is NOT NULL Constraint in sql server 2012?

231


Is sql different from sql server?

156


What does truncate do?

175