How do database indexes work?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

How to write character string constants or literals in ms sql server?

0 Answers  

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

ow to bring suspect mode datbase online from scratch

0 Answers  

---

---

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

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,

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

How to use union to merge outputs from two queries together in ms sql server?

0 Answers  

---