/*使用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)