check if cursor already exists

Splendid Shrew answered on May 5, 2020 Popularity 4/10 Helpfulness 9/10

answer check if cursor already exists

Comment

IF CURSOR_STATUS('global','myCursor')>=-1
BEGIN
 DEALLOCATE myCursor
END

Popularity 4/10 Helpfulness 9/10 Language whatever

Tags: cursor exists whatever

Link to this answer
Share Copy Link

Contributed on May 05 2020

Splendid Shrew

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.