declare @t table(tab_time datetime)
insert into @t select getdate()
update @t set tab_time='2006-2-14'
select * from @t
/*
tab_time
------------------------------------------------------
2006-02-14 00:00:00.000
*/
insert into @t select getdate()
update @t set tab_time='2006-2-14'
select * from @t
/*
tab_time
------------------------------------------------------
2006-02-14 00:00:00.000
*/
update table1 set tab_time=cast('2006-2-14' as datetime)
以前好像也曾经写错过,难怪觉得错误提示这么熟,呵呵.如果提示命令出错就方便多了,它提示=号附近出错,真晕.谢谢大家,晚上要加班了,客户前两天把服务器日期调错一年,基本得人工鉴别日期了.