sql存储过程例子

create proc Get_Stu_Search
@name varchar(100),
@tel varchar(100)
as

begin

declare @sql varchar(3000)
set @sql='select * from stu where 1=1'

if len(@name)>0
begin
set @sql=@sql+' and [name] like ''%'+@name+'%'''
end

if len(@tel)>0
begin
set @sql=@sql+' and tel like ''%'+@tel+'%'''
end

exec(@sql)

end