if(@ShipDate2 IS NOT NULL AND @ShipDate2 <> '')
BEGIN
SET @Where = @Where+ ' AND DATEDIFF(S,A.出荷日時,'+@ShipDate2+')>0'
END
存储过程中的时间比较大小
最新推荐文章于 2024-06-04 11:15:21 发布
if(@ShipDate2 IS NOT NULL AND @ShipDate2 <> '')
BEGIN
SET @Where = @Where+ ' AND DATEDIFF(S,A.出荷日時,'+@ShipDate2+')>0'
END