电脑知识交流-SQL Server 2008连载之数据类型三[安易免费财务软件交流论坛]

以文本方式查看主题

-  安易免费财务软件交流论坛  (http://anyicw.com/bbs/index.asp)
--  电脑知识交流  (http://anyicw.com/bbs/list.asp?boardid=11)
----  SQL Server 2008连载之数据类型三  (http://anyicw.com/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"
)