Answer / govardhana r

DECLARE @var1 varchar(20), @var2 varchar(20)

declare cursor_name cursor for
select val1,val2 from table_name

open cursor_name

fetch next from cursor_name
into @var1, @var2

while @@FETCH_STATUS = 0
begin
-----
-----
-----
fetch next from cursor_name
into @var1, @var2
end

close cursor_name
deallocate cursor_name

Answer / ranjith kumar

declare cursor_name cursor for
select * from table_name
open cursor_name
fetch next from cursor_name

Which virtual table does a trigger use?

3 Answers  

---

how do u find least salary in a table

4 Answers  

---

What is indexing and its types?

0 Answers  

---

what's the maximum size of a row? : Sql server database administration

0 Answers  

---

When you use @@error and try-catch?

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

What is forward - only cursors / read only cursor?

0 Answers  

---

How to create a stored procedure with a statement block in ms sql server?

0 Answers  

---

How to update muliple row in single query?

0 Answers   MCN Solutions,

---