sql-server - 无法为日期类型的表列找到超出范围的值

Question

执行查询 DBCC CHECKDB WITH NO_INFOMSGS 失败，出现以下错误:

Page (1:2772455), slot 8 in object ID 689489585, index ID 1, partition ID 72057594305052672, alloc unit ID 72057594619953152 (type "In-row data"). Column "Date" value is out of range for data type "datetime".

将列更新为合法值。

我在为数据库的特定表运行 DBCC checkDB 命令时收到上述消息当我尝试通过运行以下查询来获取该表的日期列时:-

select [date] 
from  [TableName] 
where [Year] = 2011 
  and Month = 1 
  and [Date] < '1753-01-01'
  and Date > '9999-12-31'

Answer 1

您可以像这样尝试使用 Between 关键字:-

  select [date] from  [TableName] where [Year]=2011 and Month=1 and [Date] between ('1753-01-01','9999-12-31')