模糊查询

sql="select*fromtablewhere"
ifname<>""then
sql=sql&"name1='"&变量&"'"
endif
ifbelong1<>""then
sql=sql&"name2='"&变量&"'"
endif
ifbelong2<>""then
sql=sql&"name3='"&变量&"'"
endif
ifbelong3<>""then
sql=sql&"name4='"&变量&"'"
endif

createprocspyourname
(
@name1varchar(20),
@name2varchar(20),
@name3varchar(20),
@name4varchar(20),
@name5varchar(20) )
WITHENCRYPTION
as
setnocounton
declare@SQLvarchar(5000) set@SQL='selectname1,name2,name3,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)