--看看吧^^

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

*/