改动如下:CREATE PROCEDURE temp
@num int output
as
declare @sql varchar(200)
set @sql='select ['+ cast(@num As varchar)+']=count(id) from yzsw'
exec (@sql)
print @num
print @sql
GO
@num int output
as
declare @sql varchar(200)
set @sql='select ['+ cast(@num As varchar)+']=count(id) from yzsw'
exec (@sql)
print @num
print @sql
GO
declare @num int
set @sql='select @num=count(id) from yzsw'
exec sp_executesql @sql,N'@num int output',@num output
select @num