create procedure GetCount
@TableName varchar(16)
asdeclare @Text nvarchar(2000)
,@ACount varchar(100) --如果不定义大小,则默认长度为1
set @Text='select @ACount=h.a from (select Count(OPType) as a from '+@TableNameexec sp_executesql @Text,N'@ACount varchar(100) out',@ACount out
@TableName varchar(16)
asdeclare @Text nvarchar(2000)
,@ACount varchar(100) --如果不定义大小,则默认长度为1
set @Text='select @ACount=h.a from (select Count(OPType) as a from '+@TableNameexec sp_executesql @Text,N'@ACount varchar(100) out',@ACount out
@TableName varchar(16)
asdeclare
@Text nvarchar(2000)
@ACount varchar(20)
set @Text='select '+@ACount+'=h.a from (select Count(OPType) as a from '+@TableNameexec sp_exceutesql @Text