Answer Posted / kokila

When will be use cursor need to perform following steps:-

1. DECLARE CURSOR

2. OPEN

3. FETCH

4. @@FETCH_STATUS

5. CLOSE

6. DEALLOCATE


1.DECLARE cursor_name CURSOR FOR SELECT_statement;

2.OPEN cursor_name;

3.FETCH cursor_name INTO variable list;

5.CLOSE cursor_name;

6.DEALLOCATE cursor_name;

Cursor is the current position of recordset.There are 4
types of cursors.
1.forward Only (Default)
2.Static
3.Keyset
4.Dynamic

What are the advantages of stored procedure in sql server?

887

---

How to set database to be read_only in ms sql server?

999

---

How to change server name in sql server?

1176

---

What is partition, how will you implement it? : sql server analysis services, ssas

1040

---

How would you use user_constraints table in DB?

1000

---

What are the joins in sql server? : sql server database administration

998

---

What is transaction server isolation?

1030

---

What is SQL Azure Fabric?

110

---

What is a result set object returned by odbc_exec()?

1017

---

Explain the advantages of merge replication?

946

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1022

---

What do you mean by the term 'normalization'?

1192

---

Tell me the difference between clustered and non-clustered index?

931

---

Why we use the openxml clause?

1003

---

What is difference between count (*) and count 1?

919

---