--看看吧^^ CREATE TABLE #temp ( test datetime ) go --SQL: INSERT #temp SELECT 1.1 UNION ALL SELECT 1 GO --SQL: INSERT #temp SELECT ‘2011-1-1‘ UNION ALL SELECT GETDATE() GO SELECT * FROM #temp /* 1900-01-02 02:24:00.000 1900-01-02 00:00:00.000 2011-01-01 00:00:00.000 2011-04-08 01:29:47.673 */
http://www.itnose.net/detail/6225676.html
原文：http://www.cnblogs.com/CodeGear/p/5202390.html