CREATE TYPE Date FROM VARCHAR(10) NOT NULL ; go DECLARE @T TABLE (Date Date) INSERT @T SELECT GETDATE() SELECT CAST(Date AS DATETIME) AS 轉換日期,Date FROM @T 轉換日期 Date 2010-06-25 00:00:00.000 06 25 2010
datetime 和timestamp--日期類型和用於記錄版本
CREATE TABLE #(NAME NVARCHAR(10),ID TIMESTAMP) INSERT #(Name) SELECT 'a' go SELECT * FROM # /* NAME ID a 0x0000000000000954*/goUPDATE # SET NAME=NAME--每次更新都會變化 GO SELECT * FROM # /* NAME ID a 0x0000000000000956 */
FROM VARCHAR(10) NOT NULL ;
go
DECLARE @T TABLE (Date Date)
INSERT @T SELECT GETDATE()
SELECT CAST(Date AS DATETIME) AS 轉換日期,Date
FROM @T
轉換日期 Date
2010-06-25 00:00:00.000 06 25 2010
CREATE TABLE #(NAME NVARCHAR(10),ID TIMESTAMP)
INSERT #(Name) SELECT 'a'
go
SELECT * FROM #
/*
NAME ID
a 0x0000000000000954*/goUPDATE # SET NAME=NAME--每次更新都會變化
GO
SELECT * FROM #
/*
NAME ID
a 0x0000000000000956
*/