What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

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,

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

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

1 Answers  

---

What is cursor in ms sql server?

0 Answers  

---

---

What are different types of data sources?

0 Answers  

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

how you can list all the tables in a database?

0 Answers  

---