一存储过程默认参数问题
我有一存储过程:
Create Proc TreeViewClik @Equipment char(20) = '%'
as
select a.EquiNum,
a.EquiName,
a.EquiState,
b.CompName,
c.KindName
From Table_Datum a
left join Table_Fact b on a.FactNum = b.FactNum
left join Table_Kind c on a.KindNum = c.KindNum
where a.EquiName like @Equipment
我想在不输入参数时查找所有记录,但执行
Exec TreeViewClik 时一条记录也查不出来。
但这样就可以:
select a.EquiNum,
a.EquiName,
a.EquiState,
b.CompName,
c.KindName
From Table_Datum a
left join Table_Fact b on a.FactNum = b.FactNum
left join Table_Kind c on a.KindNum = c.KindNum
where a.EquiName like '%'
为什么?谢谢