Answer Posted / ravi148

hi,

dileep is exactly correct , arun .. iam sorry to say ur
wrong

suppose for employee table, write as
DECLARE curTemp SCROLL CURSOR FOR
SELECT TOP 2 * from EMPLOYEE
OPEN curTemp
FETCH LAST FROM curTemp
CLOSE curTemp
DEALLOCATE curTemp

What is the difference between getdate and sysdatetime?

1065

---

What are pages and extents? : SQL Server Architecture

1073

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2054

---

Does index slows down insert statements?

1047

---

How can sql server instances be hidden?

1030

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

1037

---

What are different types of join?

1378

---

Explain how you can configure a running aggregate in SSRS?

169

---

What is openxml in sql server?

1224

---

How many levels of sp nesting is possible?

1102

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1802

---

What is the chart in report?

165

---

Tell me what is de-normalization and what are some of the examples of it?

1098

---

How would we use distinct statement? What is its use?

1125

---

What is tcl in sql server?

1172

---