Ms sql 2000 动态组合条件

Select
A.ID, A.TypeName, A.Code,
A.Content, A.BuildIn, A.ParentID, B.Content CategoryDisplayName,
B.BuildIn CategoryBuildIn, B.RefTableName
From Code A
left join Code B on(A.TypeName = B.Code and B.TypeName = #39CodeCa + tegoryName#39)
where
(
(@TypeName is null) or (A.TypeName = @TypeName))
and ((@Content is null ) or (A.Content = @Content))
and ((@Code is null) or (A.Code = @Code))
and ((@BuildIn is null) or (A.BuildIn = @BuildIn))
and ((@ID is null) or (A.[ID] = @ID))
and ((@CategoryBuildIn is null) or (B.BuildIn = @CategoryBuildI + n))
and ((@ParentID is null) or (A.ParentID = @ParentID))
)

这段代码能在SQL SERVER 2000 上跑

如果参数为空,那么对因的Where 条件不起作用