存储过程变量问题(100分)

CREATE PROCEDURE test(@p nvarchar(64),@tbname nvarchar(16),@columnname nvarchar(16)) &nbsp;<br>as<br>declare <br>&nbsp;@sqlstr nvarchar(256),@t int<br>[set @sqlstr=N'select select count(*) as count from '+@tbname+N' where'+@columnname+N'=@p'<br>&nbsp;exec sp_executesql @sqlstr,N'@t int output,@p varchar(64)',@t output,@p]<br>go<br><br>@t 取不了count 的值<br><br>表名 列名 和 符合条件的值 @p 都是变量<br>@t 用来保存记录数<br><br>请问 [] 里面的语句要怎么写<br>谢谢！！

各位大侠帮帮忙

怎么关注的这么少？？

set @sqlnew= 'select @maxkmcd1 = max(len(hsxmmc2)) from '+ @a<br>&nbsp;exec sp_executesql @sqlnew,N'@maxkmcd1 int output',@maxkmcd1 &nbsp;output

alter PROCEDURE test(@p nvarchar(64),@tbname nvarchar(16),@columnname nvarchar(16)) &nbsp;<br>as<br><br>&nbsp; declare @sqlstr nvarchar(256)<br>&nbsp; DECLARE @ParmDefinition nvarchar(256)<br>&nbsp; declare &nbsp;@t int<br>&nbsp; set @sqlstr=N'select @CountOut=count(*) from '+ quotename(@tbname)+' where '+@columnname+'=@p_1'<br>&nbsp; set @ParmDefinition=N'@CountOut int output,@p_1 varchar(64)'<br>&nbsp; EXECUTE sp_executesql @sqlstr,@ParmDefinition,@p_1=@p,@CountOut=@t output<br>&nbsp; select @t<br>go

Adao213,<br>提示 @tbname 附近有错

quotename(@tbname)<br><br>不要quotename

谢谢