Answer / gunasekaran

delete from table_name where ( condition )

Answer / ram suresh.l

Delete (primarykey number ex:empid) from databasename

Explain couple pf features of SQL server

2 Answers  

---

What are the advantages of log shipping?

0 Answers  

---

How to rebuild the master database?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---

What is named query? : sql server analysis services, ssas

0 Answers  

---

Write a sql query to sort on different column name according to the parameters passed in the function?

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 count rows with the count(*) function in ms sql server?

0 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---