如何使用insert Insert select语句插入多个行？
如何使用insert Insert select语句插入多个行？
提问于 2016-11-25 08:46:29
这是我的查询，注释行是我要插入的
insert into tbl_StockTransactions(ItemCode,TransactionDate,Narration,Docid,ReferenceNo,Qty,Price,UserId,BranchCode,StaffCode) select ItemCode,getDate(),Description,PostingDocid,'New Ref',Qty,Price,'uid','bc','sc' from tbl_PostingDetailsStock where PostingReference='A000275'
--select ItemCode,getDate(),Description,PostingDocid,'New Ref',Qty,Price,'uid','bc','sc' from tbl_PostingDetailsStock where PostingReference='A000276'; 回答 3
Stack Overflow用户
回答已采纳
发布于 2016-11-25 09:00:06
试试下面的代码：
insert into tbl_StockTransactions(
ItemCode, TransactionDate, Narration, Docid, ReferenceNo, Qty,
Price, UserId, BranchCode, StaffCode
)
SELECT ItemCode, getDate(), Description, PostingDocid, 'New Ref', Qty,
Price, 'uid', 'bc', 'sc'
FROM tbl_PostingDetailsStock
WHERE PostingReference IN ('A000275','A000276')Stack Overflow用户
发布于 2016-11-25 08:49:34
insert into tbl_StockTransactions(ItemCode,TransactionDate,Narration
,Docid,ReferenceNo,Qty,Price,UserId,BranchCode,StaffCode)
select ItemCode,getDate(),Description,PostingDocid,'New Ref',Qty,Price,'uid','bc','sc' from tbl_PostingDetailsStock
where PostingReference IN ('A000275','A000276')Stack Overflow用户
发布于 2016-11-25 09:10:50
select ItemCode,getDate(),Description,PostingDocid,'New Ref',Qty,Price,'uid','bc','sc'
into tbl_StockTransactions
from tbl_PostingDetailsStock
where PostingReference='A000275'页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/40800850
复制相关文章
相似问题
腾讯云开发者
