22,210
社区成员
发帖
与我相关
我的任务
分享
--TRY
CREATE PROCEDURE plist1
@keyWord varchar(50)
AS
declare @sql varchar(2000)
set @sql='select * from student where 1=1'
if(@keyWord!='')
begin
set @sql=@sql+' and name like ''%'+@keyWord+'%'''
exec(@sql)
end
GO
CREATE PROCEDURE plist1
@keyWord varchar(50)
AS
declare @sql varchar(2000)
set @sql='select * from student where 1=1'
if(isnull(@keyWord,'')!='')
begin
set @sql=@sql+' and name like ''%'+@keyWord+'%'''
end
exec(@sql)
GO
CREATE PROCEDURE plist1
(@keyWord varchar(50) )
AS
declare @sql varchar(2000)
set @sql='select * from student where 1=1'
if(@keyWord<>'')
begin
set @sql=@sql+' and name like ''%'+@keyWord+'%'''
end
exec(@sql)
GO