Answer Posted / shashikant

select min(id) from cms_dfm where id in (SELECT TOP 2 ID
from CMS_DFM Order by
ID desc)

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1059

---

Is sql server difficult to learn?

968

---

what is checksum in sql server.........???

1745

---

How to convert a table data in XML format in sql server?

2594

---

Explain the dbcc pintable command when would you use it?

968

---

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

1185

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

966

---

What is role playing dimension with two examples? : sql server analysis services, ssas

1052

---

What are different types of raid levels?

1235

---

How can I create a new template for import ? : sql server management studio

1113

---

How to create function with parameter in sql server?

1158

---

Define master database?

1141

---

What are the new features of sql server 2012 reporting service?

141

---

What are the types of dml?

1029

---

Is there any difference between the primary key and unique key?

1042

---