What are the triggers in sql?

0 Answers  

---

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---

What is attribute? : sql server analysis services, ssas

0 Answers  

---

---

What is a file group?

0 Answers  

---

How sql server enhances scalability of the database system?

0 Answers  

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

---

What are the different editions available in sql server 2000?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

About Indexed Views? with example? plz reply...

2 Answers  

---