笔记304 使用数据导入导出向导,导入excel表格到sqlserver里 2013-6-22

笔记304 使用数据导入导出向导,导入excel表格到sqlserver里  2013-6-22

 1 --使用数据导入导出向导,导入excel表格到sqlserver里  2013-6-22
 2 USE [pratice]
 3 GO
 4 CREATE TABLE [dbo].[UserInfo] (
 5 [ID] [int] IDENTITY( 1,1 ) NOT NULL,
 6       [CardNo] [char] (10) COLLATE Chinese_PRC_CI_AS NULL,
 7       [UserName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
 8       [Sex] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
 9       [UserMajor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
10       [UserTelephone] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
11       [UserOneCard] [decimal] (18, 0) NULL,
12       [UserEmail] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
13       [UserQQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL,
14       [UserCompany] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL,
15       [UserAddress] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
16       [UserPhoto] [image] NULL
17       
18        )
19 --    DROP TABLE [dbo].[UserInfo]
20 SELECT * FROM [dbo] .[UserInfo]

 

posted @ 2013-08-04 21:21 桦仔 阅读(...) 评论(...)  编辑 收藏