//存储过程
Create procedure TestVarChar(
@pSql text
)AS
exec(@pSql);
GO
//调用存储过程
execute TestVarChar 'select * from test';
//第二个示例
create proc CheckDuplicate(@checkcode varchar(255))
as
select qyid from qysign where qyrfidcheckcode = @checkcode;
declare @checkcode varchar(255);
set @checkcode = '4ce1dbd15eb6f77decc1c23b445ef7aa';
exec CheckDuplicate @checkcode; //一定要注意这里,参数是不带括号的
exec CheckDuplicate '4ce1dbd15eb6f77decc1c23b445ef7aa';这样调用也是可以的