Answer Posted / chandran

There is a table like this: tablename: example


Name Age
chandran 23
ranjith 24
chandran 23

In this table the name:chandran and age:23 are the
duplicate records .so we need to delete this using this
sql statements


delete from example group by name,age having count>1

What are the three different part of rdl file explain them?

265

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1497

---

How to find which stored procedure is currently running in sql server?

973

---

What are ddl triggers and types of ddl trigger?

1029

---

What is a group function explain with an example?

978

---

What is the difference between sdf and mdf?

1290

---

Data table as parameter in sql server?

1034

---

When would you use it?

982

---

What do you understand by triggers and mention the different types of it?

915

---

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

889

---

What is create command?

962

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1034

---

Determine when an index is appropriate?

1064

---

What the different types of Replication and why are they used?

1055

---

What are the types of lock supported by ?

1036

---