Answer Posted / dharmesh

your table look like this and want to delete duplicate
record

chandran 23
ranjith 24
chandran 23


delete top(1) from tablename where name='chandran' and
age=23

What is the difference between grant and with grant while giving permissions to the user?

1025

---

Why we use the openxml clause?

1055

---

What is the difference between locking and multi-versioning?

1038

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

958

---

Explain system views?

1130

---

What is fill factor and pad index?

1060

---

What are the mathematical functions supported by sql server 2005?

1125

---

What is transaction server implicit?

1064

---

How much memory that we are using in Logshipping Concept?

1844

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1083

---

What do you know about system database? : SQL Server Architecture

1036

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

---

What is the purpose of indexing?

1090

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

1030

---

How to delete an existing database user?

1079

---