isNull的使用

/*使用isNull進行靈活的搜索*/ declare @productId int declare @startdate datetime declare @standardCost money set @ProductID=711 select ProductId,StartDate,standardCost from Production where ProductId= isnull(@productId,ProductID) and StartDate =isnull(@startdate,StartDate) /*使用isNull進行靈活的搜索*/ declare @productId int declare @MinStandardCost int declare @MaxStandardCost int Set @MinStandardCost=3.3 Set @MaxStandardCost=10.0 select ProductID,StartDate,StandardCost from Production where ProductId=IsNull(@ProductID,ProductID) and StandardCost between isNull(@MinStandardCost,StandardCost) and isNull(@MaxStandardCost,StandardCost) /*當兩個表達是相等是返回null 否則返回第一個表達式*/ declare @Value1 int declare @Value2 int set @Value1=55 set @Value2=955 select NullIf(@Value1,@Value2)