What are various limitations of the views?

0 Answers  

---

What is a Trace frag?Where can we use this?

1 Answers  

---

How to define the name and server for a new dsn?

0 Answers  

---

Does index speed up select statements?

0 Answers  

---

Define Joins?

0 Answers   HCL,

---

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

what is a cursor and what is its use?

2 Answers   L&T,

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

What is nested transaction?

0 Answers  

---

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

---

How to Get the last identity value used

4 Answers  

---