我创建了一个日期时间选项,当值为空或空白时,我尝试将其输入到 sql 表中,它以 1900-01-01 的形式进入表。有没有办法创建一个 sql 语句来使这个值为 NULL 而不是 0?
UPDATE animals_table
SET
animalname = 'Mary'
animaltype = 'Husky'
WHERE
animalid = '123456'
我之前读过案例陈述,我不知道这是否是正确的方向,如果是这样,这就是我开始的地方。
UPDATE animals_table
SET
animalname = 'Mary'
animaltype = 'Husky'
WHERE
animalid = '123456'
AND CASE
WHEN
dategiven = '1900-01-01'
THEN
dategiven = NULL;
试试这个NULLIF
SQL2008+
UPDATE animals_table
SET
animalname = 'Mary'
,animaltype = 'Husky'
WHERE
animalid = '123456'
and ISNULL(NULLIF(dategiven,'1900-01-01'),'') = ''
或
UPDATE animals_table
SET
animalname = 'Mary'
,animaltype = 'Husky'
WHERE
animalid = '123456'
and NULLIF(dategiven,'1900-01-01') IS NULL