存储过程怎样写能实现模糊查询? 源码给出 。很短
ALTER PROCEDURE customerid
@attribname nvarchar(15),@customerid int,@address nvarchar(20)
as
select customerid,attribname,companyname,contact,phone,fax,address
from "table2"
where attribname=@attribname or
customerid=@customerid or
address=@address
RETURN