clickhouse 批量插入数据_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
)

2、批量插入数据

insert into 表名  select * from 表
--或
insert into 表名（字段1，字段2）  select 字段1，字段2 from 表

-

insert into sys_web_UserPermissions (UserCode,xType,ElementName,Permission,Modifier,ModifyDate,remark,Usertype)
(

select