Update declare-cursor-transact-sql.md

[HugoKornelis]

Reflect that STATIC OPTIMISTIC is converted to STATIC READ_ONLY without warning.

[prmerger-automator[bot]]

@HugoKornelis : Thanks for your contribution! The author(s) have been notified to review your proposed change.

[learn-build-service-prod[bot]]

Learn Build status updates of commit 4a484e0:

:white_check_mark: Validation status: passed

File	Status	Preview URL	Details
docs/t-sql/language-elements/declare-cursor-transact-sql.md	:white_check_mark:Succeeded

For more details, please refer to the build report.

For any questions, please:

• Try searching the learn.microsoft.com contributor guides
• Post your question in the Learn support channel

[Court72]

@rwestMSFT

Can you review the proposed changes?

When the changes are ready for publication, add a #sign-off comment to signal that the PR is ready for the review team to merge.

#label:"aq-pr-triaged" @MicrosoftDocs/public-repo-pr-review-team

[rwestMSFT]

Acknowledged.

[rwestMSFT]

@HugoKornelis Still waiting for PG to review.

[rwestMSFT]

Thanks for your feedback, @thesqlsith. I'll take these comments into an internal PR and handle it there.

@HugoKornelis You'll still get credit for this change.

Once the internal PR is merged, this one will automatically close.