Answer Posted / dileep.t

----------------------------------
:), This will also work, without additional columns in
result
---------------------------------

DECLARE curTemp SCROLL CURSOR FOR
SELECT TOP 2 * from <TABLE_NAME>
OPEN curTemp
FETCH LAST FROM curTemp
CLOSE curTemp
DEALLOCATE curTemp

What is difference between rownum and row_number?

1022

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1002

---

Explain use of expression builder.

1069

---

How many types of local tables are there in sql server?

976

---

What is the maximum size of sql server database?

1058

---

How do you migrate data from mssql server to azure?

167

---

How do you delete duplicate rows in sql server?

1001

---

What are the drawbacks of reporting in ssrs?

159

---

Do you know what are the properties of the relational tables?

1067

---

Which sql server table is used to hold the stored procedure scripts?

1109

---

What is Extended user-defined?

1029

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1075

---

Give an example of SQL injection attack ?

1048

---

What is cursors? And what are the different types of cursor?

1194

---

How can you tell if a database object is invalid?

1114

---