PB9对自定义SQL语句的检测很奇怪

---

结论

在PB9中，alter + update 组合语句需要注意分开写，两者之间加 go 也不行

---

举例：

create + insert 组合语句：
SQLserver2008数据库执行成功
PB9执行成功

//语句一
ls_sql = "create table T_student (~r~n" +&
                "[id] [tinyint] IDENTITY(1,1) NOT NULL,~r~n" +& 
                "[stu_id] varchar(10) NOT NULL,~r~n" +& 
                "[stu_name] [varchar](20) NOT NULL) ~r~n" +& 
                "insert T_student (stu_id, stu_name) values ('S2010101','小红')~r~n" +& 
                "insert T_student (stu_id, stu_name) values ('S2010102','小明')"
EXECUTE IMMEDIATE :ls_sql  using sqlca;

---

alter + update 组合语句：
SQLserver2008数据库执行失败
PB9执行失败

//语句二
ls_sql = "alter table T_student add stu_class varchar(10) null ~r~n" +& 
         "update  T_student set ~r~n"
EXECUTE IMMEDIATE :ls_sql  using sqlca;

---

alter + update组合语句加上go
SQLserver2008数据库执行成功
PB9执行失败

//语句三
ls_sql = "alter table T_student add stu_class varchar(10) null ~r~n" +& 
         "go ~r~n"+& 
         "update  T_student set stu_class = '一班' ~r~n"+& 
         "go"
EXECUTE IMMEDIATE :ls_sql  using sqlca;