sqlserver insert into 批量插入数据

2023-03-20 00:00:00 专区 订阅 付费 计算所 工作量

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
)

相关文章