insert into Register(
PTitle,Uname,Upwd,UQus,UAns,RegCom_C,RegState_C,RegPro_C,RegCity_C,Tel,Fax,Email,
Url,RegAdr,ZipCode, MailAdr, ComKind,industry,enterprise,Manager 
)
values ('ptitle_1','uname_1','Upwd_1','UQus','UAns','RegCom_C_1','RegState_C_1','RegPro_C_1','RegCity_1','Tel_1',
'Fax_1','Email_1','Url_1','RegAdr','ZipCode','MailAdr_1','ComKind','industry_1',
'enterprist_1','Manager_1'
)

CREATE TABLE [dbo].[Register] (
	[PTitle] [varchar] (50) NOT NULL ,
	[Uname] [varchar] (50) NULL ,
	[Upwd] [varchar] (50) NULL ,
	[JoinTime] [datetime] NULL ,
	[RegCom_C] [varchar] (50) NULL ,
	[RegState_C] [varchar] (50) NULL ,
	[RegPro_C] [varchar] (50) NULL ,
	[RegCity_C] [varchar] (50) NULL ,
	[Tel] [varchar] (50) NULL ,
	[Fax] [varchar] (50) NULL ,
	[Email] [varchar] (50) NULL ,
	[Url] [varchar] (50) NULL ,
	[RegAdr] [varchar] (50) NULL ,
	[ZipCode] [varchar] (50) NULL ,
	[MailAdr] [varchar] (50) NULL ,
	[ComKind] [varchar] (50) NULL ,
	[industry] [varchar] (50) NULL ,
	[Manager] [varchar] (50) NULL ,
	[enterprise] [varchar] (50) NULL ,
	[UID] [int] IDENTITY (1, 1) NOT NULL ,
	[UQus] [varchar] (50) NULL ,
	[UAns] [varchar] (50) NULL 
) ON [PRIMARY]