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

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 6784

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

1597

ow to bring suspect mode datbase online from scratch

972

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1089

wat new abt truncate in sql server

HCL, HP,

2 4445

how to use DTS package in 2000,2005,2008 in sql server

Microsoft,

1083

on line cluster can we make if yes tell me the procedure

Microsoft,

1109

which backup strategy you are following at ur company

1303

your distribution database is full what will u do

1246

Differences between logshipping and mirroring

Microsoft, Syntel,

1 3710

tell me the disaster recovery plan

Microsoft,

1583

application server is slow what may be the problem

Microsoft,

1357

Define the term DML, DDL and DTL?

1 25268

Creating Tables Using SELECT

1 2020

How can I create a table from another table without copying any values from the old table?

3 3627







Un-Answered Questions { SQL Server }

What is the command used to check locks in microsoft sql server?

138


Can primary key be null?

98


What is user-defined functions? What are the types of user-defined functions that can be created?

147


How can we solve concurrency problems?

142


Distinguish between nested subquery and correlated subquery?

166






How global temporary tables are represented and its scope?

147


Explain some stored procedure creating best practices or guidelines?

128


How to delete existing triggers using "drop trigger"?

147


What is perspective, have you ever created perspective? : sql server analysis services, ssas

129


Comment,Datatypes are unlimited

1197


can SSRS reports Cache results?

27


How to create a view with data from multiple tables?

144


Write query to return all rows sql?

152


What are the different types of subquery?

136


Define Wed Edition in SQL Azure?

24