Answer Posted / shashikant

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

How do I view a stored procedure in sql server query?

918

---

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

1084

---

What is function of master database?

114

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

949

---

What samples and sample databases are provided by microsoft?

1029

---

Which tcp/ip port does the sql server run on? How can it be changed?

1046

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

941

---

How to recompile stored procedure at run time?

1064

---

What do you understand by a stored procedure?

1088

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

992

---

1 01 101 01010

2042

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

1031

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

927

---

What is the log shipping?

991

---

what types of replication are supported in sql server? : Sql server database administration

1032

---