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

Describe the left outer join & right outer join. : sql server database administration

989

---

Name 3 ways to get an accurate count of the number of records in a table?

1021

---

application server is slow what may be the problem

2212

---

What are xml indexes?

939

---

Explain transaction server implicit?

978

---

How to list all schemas in a database?

1049

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1128

---

How to get the definition of a user defined function back?

1040

---

What is bulkcopy in sql?

937

---

Give an example of why you would want to denormalize a database

971

---

What is the difference between a function and a stored procedure?

1062

---

What is the sql case statement used for? Explain with an example?

988

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

974

---

What is the difference between substr and charindex in the sql server?

1085

---

What is normalization according to you and explain its different levels?

942

---