How can we determine what objects a user-defined function depends upon?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

How to find the source of a table in sql server?

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

Differnce between sel server 2000 and 2005

3 Answers  

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

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

0 Answers  

---

How to execute the cursor queries with "open" statements?

0 Answers  

---