Answer Posted / vasanthi

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;

5.DEALLOCATE cursor_name;


sample
******

DECLARE Employee_Cursor CURSOR FOR
SELECT LastName, FirstName
FROM AdventureWorks2008R2.HumanResources.vEmployee
WHERE LastName like 'B%';

OPEN Employee_Cursor;

FETCH NEXT FROM Employee_Cursor;
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Employee_Cursor
END;

CLOSE Employee_Cursor;
DEALLOCATE Employee_Cursor;

Does hive support indexing?

905

---

List some advantages and disadvantages of stored procedure?

965

---

How do I start sql server?

923

---

How to find Duplicate Records In table?

957

---

What are the restrictions that views have to follow? : SQL Server Architecture

944

---

what is the difference between count(*) and count(1) ?

1025

---

What is scrollable cursor?

983

---

Can we use where and having clause together?

977

---

what protocol both networks use? : Sql server database administration

928

---

How to implement service broker?

917

---

What is a sql join?

951

---

How to name query output columns in ms sql server?

915

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1000

---

What is server-level principal?

120

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

911

---