sql server 可选参数: between 子句的语法

问题描述

@FromDate datetime = null
@ToDate datetime = null

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

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

When any date is null, the records are not displayed. What is the correct syntax so that I can get all records if any of the dates are null.

我想到了这个:

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

谢谢.

推荐答案

尝试类似的事情

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

这篇关于SQL Server 可选参数: between 子句的语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！