create .... --定义过程参数 @str varchar(100) as --定义过程内部变量 declare @sqlstr varchar(500)select @sqlstr ="select * from myTable where id like '"+@str+"%'" exec (@sqlstr)
select @sqlstr ="select * from mytable where id like '+ '@str'+ %'"
select @sqlstr ='select * from mytable where id like '''+@str+'%'''
CREATE PROCEDURE aaa @str varchar(100) AS begin set @str=@str+'%' select * from myTable where id like @str end
--定义过程参数
@str varchar(100)
as
--定义过程内部变量
declare @sqlstr varchar(500)select @sqlstr ="select * from myTable where id like '"+@str+"%'"
exec (@sqlstr)
@str varchar(100)
AS
begin
set @str=@str+'%'
select * from myTable where id like @str
end