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 does it mean if @@cursor_row returns a negative number?

1000

---

What is the difference between push and pull subscription? : sql server replication

1224

---

How to apply filtering criteria at group level with the having clause in ms sql server?

1007

---

What is the primary use of the model database?

1096

---

What do you mean by stored techniques? How would we use it?

1043

---

How to use linked server?

1201

---

How to Insert multiple rows with a single insert statement?

1060

---

Explain active/passive and active/active cluster configurations?

1065

---

whats new about truncate in sql server 2008?

2509

---

How to create a Master database in SQL server ?

1102

---

What are logical database components? : SQL Server Architecture

1047

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

934

---

How to provide login information for a new odbc dsn?

1052

---

What is the difference between varchar and nvarchar?

949

---

Can foreign key be duplicate?

1070

---