SQL Server continue on error

iregk

Hey,

Anyone else found a way around this. Big sql script to be ran on sql server but its cumulative so parts have already been ran before. In oracle world thats fine it will throw an error about a duplicate name but continue on running the rest of the file. In SQL Server it doesn't, first error it bombs out.

Is there a switch to ignore errors and continue on processing the rest of the file?

Dr.Silly

iregk wrote: »

Hey,

Anyone else found a way around this. Big sql script to be ran on sql server but its cumulative so parts have already been ran before. In oracle world thats fine it will throw an error about a duplicate name but continue on running the rest of the file. In SQL Server it doesn't, first error it bombs out.

Is there a switch to ignore errors and continue on processing the rest of the file?

you can put a GO in between your statements.
e.g

insert into namestbl values ('a','b','22')
go
insert into namestbl values (1'''','b','22')
go
insert into namestbl values ('a','b','22')


my second statement fails here, but the script will continue and 2 rows are inserted.

iregk

Ok cool, will give that a shot. I thought there was some switch in the osql command that you can specify continue on error or something...

Dr.Silly

am afraid not

Jagera

Or look at TRY.. CATCH