drop procedure datebase1_clear; go create procedure datebase_clear (@flag int output ) as begin delete zww select @flag=1 end go表不用管我这样写怎么调试不成功呢?
沒問題的,這樣調試就可以了:declare @flag int exec datebase_clear @flag output print @flag
create procedure datebase_clear (@flag int output ) as begin TRUNCATE TABLE zww set @flag=1 end go ----------------------------- declare @flag int exec datebase_clear @flag output print @flag
go
create procedure datebase_clear
(@flag int output
)
as
begin delete zww
select @flag=1
end
go表不用管我这样写怎么调试不成功呢?
exec datebase_clear @flag output
print @flag
(@flag int output
)
as
begin
TRUNCATE TABLE zww
set @flag=1
end
go
-----------------------------
declare @flag int
exec datebase_clear @flag output
print @flag