ALTER procedure test
@a varchar(50),
@b varchar(50)
as
select customerid as 编码,companyname as 名称 from customers where
(customerid=@a or @a='')
and
(contactname=@b or @b='')
GO
exec test 'ALFKI' ,''
能执行出结果，'ALFKI' , 'Alfreds Futterkiste'
下面两个就执行不出结果，
exec test 'ALFKI' , 'Alfreds Futterkiste'
exec test '' ,'Alfreds Futterkiste'
问题出在哪呢
------解决思路----------------------
可能就是没数据吧？