Explain what are the restrictions while creating batches in sql server?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

what is the purpose of creating view is sql server 2000

13 Answers   Wipro,

---

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

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 to create new table with "create table" statements?

0 Answers  

---

Do you know the policy based administration feature of sql server 2008?

0 Answers  

---

How many triggers are possible per table?

0 Answers  

---

What is model database in sql server?

0 Answers  

---

What is a covering index?

0 Answers  

---