以文本方式查看主題 - 安易免費財務軟件交流論壇 (http://m.gangyx.cn/bbs/index.asp) -- 電腦知識交流 (http://m.gangyx.cn/bbs/list.asp?boardid=11) ---- SQL Server 2008連載之數據類型三 (http://m.gangyx.cn/bbs/dispbbs.asp?boardid=11&id=32396) |
-- 作者:炙天 -- 發布時間:2011/1/13 8:36:39 -- SQL Server 2008連載之數據類型三 "char(n)" char(4), "varchar(n)" varchar(4), "nchar(n)" nchar(4), "nvarchar(n)" nvarchar(4), "binary(n)" binary(6), "varbinary(n)" varbinary(6), "varchar(max)" varchar(max), "nvarchar(max)" nvarchar(max), "varbinary(max)" varbinary(max), "Text" Text, "Ntext" Ntext, "Image" Image ) --向各個字段插入相應的數據值 INSERT INTO testDataType( "bit","tinyint","smallint","int","bigint", "decimal(p,s)","numeric(p,s)", "smallmoney","money", "float","real", "datetime","date","time", "smalldatetime","datetime2","datetimeoffset", "char(n)","varchar(n)","nchar(n)","nvarchar(n)", "binary(n)","varbinary(n)", "varchar(max)","nvarchar(max)","varbinary(max)", "Text","Ntext","Image" ) |