Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to allow a statement to continue if an error occurs

Status
Not open for further replies.
GJP55

GJP55

Technical User
Feb 2, 2003
220
GB
Is it possible to trap an error when it occurs in T-SQL and then continue with the statement ?

I have an insert statement that I would like to continue with the remaining records if fails on one (for example if one of the fields being inserted is the wrong data type).

Is this possible without going down the cursor route ?

Thanks


 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
467
mikrom
mikrom
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
362
Volvere
V
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
294
Andrzejek
Andrzejek
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
446
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
458
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top