sqlserver insert into 批量插入数据
1、创建表
CREATE TABLE [dbo].[sys_web_UserPermissions]
(
[ID] [int] IDENTITY(1,1) primary key NOT NULL,
[UserCode] [int] NOT NULL,
[xType] [tinyint] NOT NULL,
[ElementName] [varchar](20) NOT NULL,
[Permission] [smallint] NOT NULL,
[Modifier] [varchar](20) NULL,
[ModifyDate] [datetime] NULL,
[remark] [varchar](20) NULL,
[Usertype] [int] NULL
)
相关文章