|
|
Posted by rshivaraman on 06/07/07 13:27
Hi
I am doing a check and on failing, i have a raiseerror command.
I was assuming, once proc reaches raiseerror, it would stop the proc,
but i see that the proc gives me an error message, but continues to
run thru all the rest of the steps after raiseerror.
how do i make the proc quit after reading raiseerror, only thru
labels ?
IF @CheckIFFileHasOnlyOneOutputType > 1
BEGIN
RAISERROR ('Process Stopped. Input xls file is invalid, as it has more
than one output type specified in the OutputType Column', 16, 1)
END
--more proc steps are here ...
Thanks in advance :
RS
Navigation:
[Reply to this message]
|