<div>
Within your WHILE clause try using the below approach:<br />
while (a &lt;100)<br />
-- your operation<br />
select * from table<br />
<br />
-- capture error code<br />
if @@error &lt;&gt;&nbsp;0<br />
-- &nbsp;log into some tables<br />
<br />
a = a + 1;<br />
<br />
By this approach, you will be able to run your statements without exiting out of the other processes.
</div>


Within your WHILE clause try using the below approach:
while (a <100)
-- your operation
select * from table

-- capture error code
if @@error <> 0
--  log into some tables

a = a + 1;

By this approach, you will be able to run your statements without exiting out of the other processes.

<div>
I suppose you mean T-SQL. and then, yes you can. See the code snippet for the syntax.<br />
You can also check <a href="http://blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/" rel="ugc">http://blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/</a>&nbsp;or <a href="http://msdn.microsoft.com/en-us/library/ms179296.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms179296.aspx</a><br />
<br />

<pre><code id="code-247003">BEGIN TRY
{ sql_statement |
statement_block }
END TRY
BEGIN CATCH
{ sql_statement |
statement_block }
END CATCH
</code></pre>
</div>


I suppose you mean T-SQL. and then, yes you can. See the code snippet for the syntax.
You can also check http://blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/ [http://blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/] or http://msdn.microsoft.com/en-us/library/ms179296.aspx [http://msdn.microsoft.com/en-us/library/ms179296.aspx]



BEGIN TRY
{ sql_statement |
statement_block }
END TRY
BEGIN CATCH
{ sql_statement |
statement_block }
END CATCH


<div>
<div class="content wysiwyg-content">
I have a MS SQL 2005 server, I have a FOR WHILE<br />
<br />
Statement and it works properly on my database and do some stuff on all tables.<br />
<br />
I got a problem, for some unknown reason sometimes it get a problem on 1 field, on 1 table,<br />
<br />
I want it to bypass and continue execution and not stop at error... <br />
<br />
Something like try catch or ON ERROR RESUME NEXT<br />
<br />
Is it a case in SQL?<br />
<br />
Please advice<br />
<br />
Thanks
</div>
</div>


I have a MS SQL 2005 server, I have a FOR WHILE

Statement and it works properly on my database and do some stuff on all tables.

I got a problem, for some unknown reason sometimes it get a problem on 1 field, on 1 table,

I want it to bypass and continue execution and not stop at error... 

Something like try catch or ON ERROR RESUME NEXT

Is it a case in SQL?

Please advice

Thanks

TRY CATCH in SQL QUERY

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.