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 do you understand by replication in sql server? Mention the different types of replication in sql server.

506

---

how to create “alternate row colour”?

109

---

How will you know when statistics on a table are obsolete?

606

---

What are approximate numeric data types in ms sql server?

589

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

493

---

---

What do you understand by replication in sql server?

574

---

What is the rdl file?

88

---

Differentiate sql server reporting services vs. Crystal reports?

150

---

what is a traditional network library for sql servers? : Sql server database administration

463

---

How we can refresh the view?

596

---

what is difference between NULL and ISNULL in SQL Server 2008?

579

---

Does union all remove duplicates?

607

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

572

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

484

---

What is BCP? When does it used in sql server 2012?

578

---