What are the steps to create a cursor? | SQL Server interview questions

Below are the basic steps to execute a cursor:
=> Declare
=> Open
=> Fetch
=> Operation
=> Close and Deallocate
Steps to process a cursor
                                                          Steps to process a cursor
This is a small sample which uses the "person.address" class. This T-SQL program will only display records which have "@Provinceid" equal to "7".

0 comments:

Post a Comment

Blogger news