After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---

How do I find information about the install locations for the various instances running on a computer?

0 Answers  

---

How do you delete duplicate rows in sql server?

0 Answers  

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

Explain couple pf features of SQL server

2 Answers  

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---

What are scalar functions?

0 Answers  

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

Explain concepts of analysis services?

0 Answers  

---