我用vb+ado+mssql2000 调用下面的存储过程CREATE PROCEDURE aa AS
truncate table bb
insert into bb select * from hydab
select * from bb
GO出现错误“对象关闭时,操作不被允许”
但我将存储过程改为CREATE PROCEDURE aa AS
select * from bb
GO就能正常运行,这是为什么?
truncate table bb
insert into bb select * from hydab
select * from bb
GO出现错误“对象关闭时,操作不被允许”
但我将存储过程改为CREATE PROCEDURE aa AS
select * from bb
GO就能正常运行,这是为什么?
CREATE PROCEDURE aa AS
set nocount on '****增加这一行
truncate table bb
insert into bb select * from hydab
select * from bb
GO
即可