alter proc sp_person_sel_by_name
@name varchar(50)
AS
begin
DECLARE @SQL NVARCHAR(4000) ,
@SQLCount NVARCHAR(500) ,
@SelectColumns NVARCHAR(500) ,
@TmpStartRow NVARCHAR(10) ,
@TmpPageSize NVARCHAR(10)
Select @SQL='select * from emp where name like ''%'+ @name +'%'''
EXEC(@SQL)
end
GO
exec sp_person_sel_by_name 'tom'
@name varchar(50)
AS
begin
DECLARE @SQL NVARCHAR(4000) ,
@SQLCount NVARCHAR(500) ,
@SelectColumns NVARCHAR(500) ,
@TmpStartRow NVARCHAR(10) ,
@TmpPageSize NVARCHAR(10)
Select @SQL='select * from emp where name like ''%'+ @name +'%'''
EXEC(@SQL)
end
GO
exec sp_person_sel_by_name 'tom'