Answer Posted / skumar

Hi friends, please just try out this. This works fine for me.

We have lot of methods to do this. But using temp table,
drop the original table,retain the temp as orinial is not a
good pratice.

When u have large no of data it will affect ur performance.


DELETE FROM employee WHERE((SELECT eid,COUNT(eid) FROM
employee GROUP BY eid) > 1)

What is it’s similarity with sql server?

160

---

Explain different types of lock modes in sql server 2000?

926

---

What are basics of policy management?

1090

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1500

---

What is use of except clause? How it differs from not in clause?

1017

---

Is oracle faster than sql server?

943

---

What stored procedure would you use to view lock information?

961

---

What do you mean by subquery?

1079

---

How do you clear a log file?

1036

---

Explain triggers in sql?

938

---

Determine how to use the inserted and deleted pseudo tables?

979

---

How to list all stored procedures in the current database using ms sql server?

1120

---

How to create median function?

164

---

Explain transaction server explicit transaction?

923

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2207

---