SQL - 即使出错也继续运行所有SQL语句

I have some queries like this

我有这样的问题

Alter Table Table1 ALTER COLUMN T1 varchar(MAX);
Alter Table Table1 ALTER COLUMN T2 varchar(MAX);
Alter Table Table1 ALTER COLUMN T3 varchar(MAX);

--Table2 does not have a column "R1" and is likely to give error
Alter Table Table2 ALTER COLUMN R1 varchar(MAX);

Alter Table Table2 ALTER COLUMN T1 varchar(MAX);
Alter Table Table2 ALTER COLUMN T2 varchar(MAX);
Alter Table Table2 ALTER COLUMN T3 varchar(MAX);

Possible Error

Now in the 4th statement it is likely that a message would pop because there is no field in Table2 named R1.

现在在第4个语句中，可能会弹出一条消息，因为Table2中没有名为R1的字段。

Need

I need a way so that all the statement gets executed even after receiving the error.

我需要一种方法，以便即使在收到错误后所有语句都会被执行。

My Approach

I tried to execute these statements individually to receive error message for every line but it takes too much time as it makes 7 times connection to a server which is connected to the PC by internet . So, i used all those query together to get records in one connection but it breaks the command on 4th line as the statement is invalid.

我试图单独执行这些语句以接收每一行的错误消息，但它花了太多时间，因为它连接到通过互联网连接到PC的服务器7次。所以，我一起使用所有这些查询来获取一个连接中的记录，但是由于该语句无效，它在第4行中断了命令。

Any suggestion or piece of code is appreciated

任何建议或一段代码表示赞赏

1 个解决方案

#1

Use a try-catch block:

使用try-catch块：

Alter Table Table1 ALTER COLUMN T1 varchar(MAX);
Alter Table Table1 ALTER COLUMN T2 varchar(MAX);
Alter Table Table1 ALTER COLUMN T3 varchar(MAX);

BEGIN TRY
     Alter Table Table2 ALTER COLUMN R1 varchar(MAX);
END TRY
BEGIN CATCH
     print 'error altering column R1 of Table2';
END CATCH;

Alter Table Table2 ALTER COLUMN T1 varchar(MAX);
Alter Table Table2 ALTER COLUMN T2 varchar(MAX);
Alter Table Table2 ALTER COLUMN T3 varchar(MAX);

#1