<div class="codebody" id="code83025">
createprocspyourname
(
@name1varchar(20),
@name2varchar(20),
@name3varchar(20),
@name4varchar(20),
@name5varchar(20) )
WITHENCRYPTION
as
setnocounton
declare@sqlvarchar(5000) set@sql='selectname1,name4,name5fromyourtablewhere1=1'
if@name<>''
set@sql=@sql+'andname1like''%'+@name+'%'''
if@belong1<>''
set@sql=@sql+'andname2like''%'+@belong1+'%''' if@belong2<>''
set@sql=@sql+'andname3like''%'+@belong2+'%'''
if@belong3<>''
set@sql=@sql+'andname4like''%'+@belong3+'%'''
exec(@sql)