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 conditional split?

1141

What are the types of dml?

1031

what is blocking? : Sql server database administration

1088

Explain subquery and state its properties?

1092

Explain the difference between primary keys and foreign keys?

1101

How can i Relate Tables in SSIS

1134

How do users use Report Builder with SQL Server data sources?

164

Do you know what is openxml in sql server?

1113

what are the types of indexes? : Sql server database administration

1180

How do you start single user mode in clustered installations?

987

What is a covered index?

987

What is an indexing strategy?

1069

Can we shrink data file in sql server?

1097

What are page splits?

1053

What new data source types were added in ssrs 2014?

169