6,129
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO TB
SELECT .... UNION ALL
SELECT .... UNION ALL
SELECT .... UNION ALL
SELECT .... UNION ALL
SELECT .... UNION ALL
SELECT ....
GO
--如果要插入的记录均包含前缀字符串 "销售列表-" 的话,你可以先不将其插入!
--后面去更新成 "销售列表-"+colName
--不过:我觉得我这也是多此一举!完全没有必要!
CREATE TABLE listviewCol(colName VARCHAR(30),colwidth INT, colwidthType INT, colNO INT)
INSERT INTO listviewCol(colName ,colwidth,colwidthType,colNO)
SELECT '记录ID',0,7,1 UNION ALL
SELECT '销售单',100,7,2 UNION ALL
SELECT '批号',100,7,3 UNION ALL
SELECT '商品号',100,7,4 UNION ALL
SELECT '名称',100,7,5 UNION ALL
SELECT '规格',100,7,6 UNION ALL
SELECT '单位',100,7,7 UNION ALL
SELECT '数量',100,7,8 UNION ALL
SELECT '单价',100,7,9 UNION ALL
SELECT '销售金额',100,7,10 UNION ALL
SELECT '价格类型',100,7,11 UNION ALL
SELECT '销售日期',100,7,12 UNION ALL
SELECT '门店名',100,7,13 UNION ALL
SELECT '条码',100,7,14 UNION ALL
SELECT '商品详情',100,7,15 UNION ALL
SELECT '销售说明',100,7,16 UNION ALL
SELECT '销售员',100,7,17 UNION ALL
SELECT '是否分配',100,7,18 UNION ALL
SELECT '是否积分',100,7,19 UNION ALL
SELECT '客户号',100,7,20 UNION ALL
SELECT '录入日期',100,7,21;
UPDATE listviewCol
SET colName ='销售列表-'+colName
SELECT * FROM listviewCol;
insert into listviewCol(colName ,colwidth,colwidthType,colNO)
select '销售列表-记录ID',0,7,1 union all
select '销售列表-销售单',100,7,2 union all
.........
select '销售列表-批号',100,7,3