笔记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]
