27,580
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('TB')IS NOT NULL DROP TABLE TB
GO
CREATE TABLE TB(ID INT IDENTITY,DT DATETIME)
INSERT TB SELECT '2009-12-29' WHERE ISDATE('2009-12-29')=1
INSERT TB SELECT '1000-13-33 81:81:00' WHERE ISDATE('1000-13-33 81:81:00')=1
INSERT TB SELECT '2009-12-11' WHERE ISDATE('2009-12-11')=1
SELECT * FROM TB
/*
ID DT
----------- -----------------------
1 2009-12-29 00:00:00.000
2 2009-12-11 00:00:00.000
(2 個資料列受到影響)
*/
case when IsDate(col)=1 then col eles null end