CREATE PROCEDURE dbo.存储过程1
@fengtao nvarchar(20),@zhaoying nvarchar(20)
AS SELECT DISTINCT 单位
FROM dbo.[6月] where 单号 LIKE ISNULL(@fengtao,'%')
and 转运网络 like isnull(@zhaoying,'%')
GO
<IMG>作者: wuaza 时间: 2006-8-7 20:25
估计是把空值当空字符串处理了。这样试试。
CREATE PROCEDURE dbo.存储过程1
@fengtao nvarchar(20),@zhaoying nvarchar(20)
AS SELECT DISTINCT 单位
FROM dbo.[6月] where 单号 LIKE ISNULL(@fengtao+'%','%')
and 转运网络 like isnull(@zhaoying+'%','%')
GO