批量生成 Insert into

来源：互联网发布：网络电视有百度云吗编辑：程序博客网时间：2024/06/14 22:09

实例1：一个简单的例子

select * from Popedom

select 'insert into Popedom(id,popedom_name,popedom_value) values
('+cast(id as varchar(10))+',''' + popedom_name + ''',
''' + popedom_value+ ''')' FROM Popedom

insert into Popedom(id,popedom_name,popedom_value) values   (1,'电厂一览', 'PRIV_ELECTINFO')
insert into Popedom(id,popedom_name,popedom_value) values   (2,'概算信息', 'PRIV_BUDGET')
insert into Popedom(id,popedom_name,popedom_value) values   (3,'合同信息', 'PRIV_CONTRACT')
insert into Popedom(id,popedom_name,popedom_value) values   (4,'投资信息', 'PRIV_INVESTMENT')
insert into Popedom(id,popedom_name,popedom_value) values   (5,'进度信息', 'PRIV_PROCESS')
insert into Popedom(id,popedom_name,popedom_value) values   (6,'安全信息', 'PRIV_SAFETY')
insert into Popedom(id,popedom_name,popedom_value) values   (7,'日常工作分配', 'PRIV_SETUP')
insert into Popedom(id,popedom_name,popedom_value) values   (8,'日常工作浏览', 'PRIV_AWAKE')
insert into Popedom(id,popedom_name,popedom_value) values   (9,'日常工作录入', 'PRIV_TASK')
insert into Popedom(id,popedom_name,popedom_value) values   (10,'提醒基本信息设置', 'PRIV_BASE')
insert into Popedom(id,popedom_name,popedom_value) values   (11,'个人信息设置', 'PRIV_PERSON')
insert into Popedom(id,popedom_name,popedom_value) values   (12,'超级管理员', 'PRIV_ADMIN')
insert into Popedom(id,popedom_name,popedom_value) values   (13,'设计信息', 'PRIV_DESIGN')
insert into Popedom(id,popedom_name,popedom_value) values   (14,'质量信息', 'PRIV_QUALITY')
insert into Popedom(id,popedom_name,popedom_value) values   (15,'日常工作汇报', 'PRIV_REPORT')
insert into Popedom(id,popedom_name,popedom_value) values   (16,'日常工作审核', 'PRIV_CHECK')
insert into Popedom(id,popedom_name,popedom_value) values   (17,'电厂信息录入', 'PRIV_ElECTINFO')
insert into Popedom(id,popedom_name,popedom_value) values   (18,'设计信息录入', 'PRIV_DESIGNINFO')

实例2：相对复杂一点的例子

SELECT 'INSERT INTO Previse(PreviseID,PreviseDate,PreviseInfo) VALUES
('+cast(PreviseID as varchar(10))+',''' + CONVERT(varchar(19), PreviseDate, 121) + ''',
''' + PreviseInfo + ''')' FROM Previse WHERE PreviseID > 100