How can you continue SQL query when found error?

Question

How can you continue SQL query when found error while querying?

I want to continue a query if any error will occur. I want to get the output of a certain statement and want to see if what is the last output of the query.

How can you do it in T-SQL?

You can't continue a query and ignore all errors. Assuming you mean that you would want a result set with 1,2 from the following SELECT * FROM (SELECT 1 UNION ALL SELECT CAST('X' AS INT) UNION ALL SELECT 2) T(C) — Martin Smith
– Martin Smith, Commented Jun 20, 2013 at 9:27
What is your case? If it is as per my earlier comment then no that won't do what you want. Can you be more specific about what you are trying to do? — Martin Smith
– Martin Smith, Commented Jun 20, 2013 at 9:52
When you say query, do you mean a single statement (like a single SELECT or a single INSERT or single UPDATE etc.) or a batch (as in multi-statement query)? — Andriy M
– Andriy M, Commented Jun 21, 2013 at 7:02
What is your case? What SQL do you have that you want to "continue" in case of an error? Show us a piece of code, don't leave us hanging. — Marian
– Marian, Commented Jun 21, 2013 at 7:09

Radu Gheorghiu · Accepted Answer · 2013-06-21 08:01:11Z

13

You can use a TRY-CATCH for error handling.

You can find enough documentation here : http://msdn.microsoft.com/en-us/library/ms175976.aspx

UPDATE:

After a bit more research I have found that using a GO command will allow you to continue to your next query, and you won't have to restructure your entire code with TRY-CATCH statements. I still recommend using TRY-CATCH statements to control errors, but just use GO between them.

This is the link where I found the answer: continue-executing-sql-statements-despite-errors

edited Jun 21, 2013 at 8:01

answered Jun 20, 2013 at 9:18

Radu Gheorghiu

20.6k16 gold badges78 silver badges113 bronze badges

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

4 Comments

Andriy M Over a year ago

This doesn't really explain how one can have the SQL query continue when using TRY...CATCH.

gbn Over a year ago

TRY CATCH only allows you to control error handling. Not continue.

Eon Over a year ago

This helped. I paired GO with the running of a 118mb script on SQLCMD -d <Databasename> -i <instancename> . turns out it was a single, annoying, little, enfuriating change one of the developers made causing one of my values to not find a foreign key :)

Radu Gheorghiu Over a year ago

@Noobgrammer Glad it was useful!

Collectives™ on Stack Overflow

How can you continue SQL query when found error?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related