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

How to enter date and time literals in ms sql server?

511

What is difference between cte and view?

526

What is a non clustered primary key?

515

How do you troubleshoot errors in a SQL Server Agent Job?

565

What is the difference between delete and truncate statements?

575

What is an example of a foreign key?

512

What is a matrix in ssrs?

101

How to drop an existing schema in ms sql server?

594

What is self contained multi valued query?

560

Define left outer join in sql server joins?

566

Which language rdl files made of?

100

Is natural join and equi join same?

532

What are scalar functions?

507

What are different types of subquery?

721

What is the new security features added in sql server 2014? : sql server security

569