在VB6.0中执行以下这段SQL的存储过程后总是不能实现修改,实现的是删除,想知道原因
use xskc
go
if exists(select name from sysobjects
where xtype='p' and name='xs_update1')
drop procedure xs_update1
go
create procedure xs_update1
(@xh char(8),@xm varchar(8),@xb bit,@cssj smalldatetime,@zy varchar(20),@zxf tinyint,@bz text,
@jxj real,@bgf bit,@mm varchar(10) )
as
update xs
set 姓名=@xm,性别=@xb,出生时间=@cssj,专业=@zy,总学分=@zxf,备注=@bz,奖学金=@jxj,班干否=@bgf,密码=@mm
where 学号=@xh
return
go
use xskc
go
if exists(select name from sysobjects
where xtype='p' and name='xs_update1')
drop procedure xs_update1
go
create procedure xs_update1
(@xh char(8),@xm varchar(8),@xb bit,@cssj smalldatetime,@zy varchar(20),@zxf tinyint,@bz text,
@jxj real,@bgf bit,@mm varchar(10) )
as
update xs
set 姓名=@xm,性别=@xb,出生时间=@cssj,专业=@zy,总学分=@zxf,备注=@bz,奖学金=@jxj,班干否=@bgf,密码=@mm
where 学号=@xh
return
go
在SQL中遇到Go时,会直接将前面的语句做为一个块执行