quote:

---

Originally posted by krunal1

~>i have one database script there is a lots of sql statements in one script
and I run this script in sql analyzer 2000.

For Example:
line 1 : alter table1
line 2 : alter table2
line 3 : alter table3
line 4 : alter table4

line 6 : insert into table1 ..................
line 7 : update into table2 ..................
line 8 : delete from table1 where ..................
line 9 : insert into table3 ..................
line 10 : update into table4 ..................

line 11: drop stored procedure SP1
line 12: drop stored procedure SP2
line 13: drop stored procedure SP3
line 14: drop stored procedure SP4

line 15 : create stored procedure SP1
line 17: create stored procedure SP2
line 18 : create stored procedure SP3
line 19 : create stored procedure SP4

suppose there is an error in line number 4 i want to execute the next statement after line number 4 upto line number 19

I want to handle error in this database script

---

-- errors with: Incorrect syntax near the keyword 'COLUMN'.
ALTER TABLE YourExistingTable ADD COLUMN gg INT
-- select doesn't execute
SELECT 1

-- errors with: Incorrect syntax near the keyword 'COLUMN'.
ALTER TABLE YourExistingTable ADD COLUMN gg INT
GO
-- select executes
SELECT 1

quote:

---

Originally posted by visakh16

Didnt understand the purpose of this requirement?

---