SQL Server equivalent of DECLARE CONTINUE HANDLER in MySQL?

Question

I am trying to execute following mySql statement

"DECLARE DONE INT(1) default 0;    
DECLARE CONTINUE HANDLER FOR NOT FOUND SET DONE = 1;"

in SQL Server 2005 like

" DECLARE @DONE INT,    
DECLARE CONTINUE HANDLER FOR NOT FOUND SET DONE = 1"

it gives error like

"Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'CONTINUE'.
Msg 136, Level 15, State 1, Line 1
Cannot use a CONTINUE statement outside the scope of a WHILE statement."

MySQL DECLARE ... HANDLER command

Check here: sql-server-helper.com/error-messages/msg-136.aspx - it should cover your question — Slim
– Slim, Commented Nov 20, 2012 at 7:37
You can't just type MySQL commands into SQL Server and expect them to work. It would help if you explain what DECLARE CONTINUE HANDLER actually does (or link to the docs), for the benefit of SQL Server people who may not be familiar with MySQL. — Pondlife
– Pondlife, Commented Nov 20, 2012 at 13:44

Community · Accepted Answer · 2017-05-23 10:26:53Z

2

SQL Server has no direct equivalent of the handler mechanism described in the documentation linked above. The most obvious alternatives are:

TRY...CATCH...
Write a CLR stored procedure and use .NET code to implement whatever handling code you need; this question also has some useful information

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Nov 20, 2012 at 15:01

Pondlife

16.3k6 gold badges40 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server equivalent of DECLARE CONTINUE HANDLER in MySQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related