data name score
2008-9-8 拜仁 胜
2008-9-8 奇才 胜
2008-9-8 湖人 胜
2008-9-8 拜仁 负
2008-9-8 拜仁 负
2008-9-8 奇才 胜
表格代码
create table [T_Scores]
([data] [datetime] null,
[name] [nvarchar] (50) collate chinese_prc_ci_as null,
[Score] [nvarchar] (50) collate chinese_prc_ci_as null
);
insert [T_Scores] ( [date] ,[name],[Score]) values (cast (0x00009af200000000 as datetime),N'拜仁, N'胜');
insert [T_Scores] ( [date] ,[name],[Score]) values (cast (0x00009af300000000 as datetime),N'奇才', N'胜');
insert [T_Scores] ( [date] ,[name],[Score]) values (cast (0x00009af300000000 as datetime),N'湖人', N'胜');
insert [T_Scores] ( [date] ,[name],[Score]) values (cast (0x00009af400000000 as datetime),N'拜仁', N'负');
insert [T_Scores] ( [date] ,[name],[Score]) values (cast (0x00009af200000000 as datetime),N'拜仁', N'负');
insert [T_Scores] ( [date] ,[name],[Score]) values (cast (0x00009af600000000 as datetime),N'奇才', N'胜');
疑问,请各位帮忙指教 谢谢!
一、 在 create table 中 collate chinese_prc_ci_as null 这是什么意思,表示这里写中文吗;
二、cast (0x00009af200000000 ) as datetime 这句话是将前面的转化成时间的数据类型,那前面的表示的是什么意思,16进制吗;
三、[T_Scores] ( [date] ,[name],[Score]) 字段 都用中括号括起来了,那有不用中括号的表达方式吗,如果不用中括号是不是 insert into…… 要加上 into;
谢谢指教!!
|