declare cursor_name cursor for select * from table_name open cursor

Write the Syntax for Cursors.

Question Posted / ranjith kumar

Answer Posted / ranjith kumar

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

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the web service used for reporting services?

126

What are the types of lock supported by ?

1091

what stored procedure can you use to display the current processes? : Sql server administration

1051

explain different levels of normalization? : Sql server database administration

1048

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1175

What does it mean if @@cursor_row returns a negative number?

1032

How to call a function from a stored procedure in SQL Server ?

1077

How to find the second highest salary of an employee?

1220

What is a synonym for manipulation?

1043

Can a unique index be created on a column, which contains null?

966

What are the types of ssrs?

149

What are group functions in query statements in ms sql server?

1061

How is sql server used?

1009

What is the current pricing model of SQL Azure?

104

Do you have any idea about the tcl commands?

1010