sql-server - sql server 可选参数 : syntax for between clause

Question

@FromDate datetime = null
@ToDate datetime = null

SELECT * FROM TABLE
WHERE ....
AND [PI].Date BETWEEN @FromDate AND @ToDate

当任何日期为空时，不显示记录。如果任何日期为空，我可以获取所有记录的正确语法是什么。

我想到了这个:

@FromDate datetime = '01/01/1901',
@ToDate datetime = '12/31/9999'

谢谢。

Answer 1

试试类似的东西

SELECT * FROM TABLE 
WHERE .... 
AND [PI].Date BETWEEN ISNULL(@FromDate, [PI].Date) AND ISNULL(@ToDate, [PI].Date)