Answer Posted / manju

DECLARE authors_salary CURSOR
select top2(salary) from tb_employee order by desc salary

open author_salary
FETCH NEXT FROM authors_salary into @topsalary

How to change the name of a database user?

960

---

what is spatial nonclustered index

992

---

How do you open a cluster administrator?

1053

---

How to download and install sql server 2005 books online?

1191

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1012

---

What is the datatype of rowid?

928

---

What is SQL Azure Data sync?

121

---

Explain transaction server consistency?

976

---

What is bit data type? What's the information that can be stored inside a bit column?

921

---

Mention the differences between sql server and mysql.

1016

---

Is a primary key unique?

992

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

971

---

What is openxml in sql server?

1171

---

What is change data capture (cdc) in sql server 2008?

1024

---

What are dml triggers and types of dml triggers?

983

---