34,576
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE GET_INSERT
@keyid nvarchar(50)
as
begin
--开始插入
INSERT INTO history
SELECT t.KeyID,Sales,SalesDate,A.Title,B.Title,C.Title.........
FROM product t left JOIN tbA A on A.AID=t.AID
left JOIN tbB B on B.AID=t.AID
left JOIN tbC C on C.AID=t.AID........
end
CREATE PROCEDURE GET_INSERT
@keyid nvarchar(50)
as
begin
--开始插入
INSERT INTO history
SELECT t.KeyID,Sales,SalesDate,A.Title,B.Title,C.Title.........
FROM product t INNER JOIN tbA A on A.AID=t.AID
INNER JOIN tbB B on B.AID=t.AID
INNER JOIN tbC C on C.AID=t.AID
end
+
create proc get_insert
@keyid int
as
begin
insert into history
select ......
from product t join tbA a on t.aid = a.id
join tbB b on t.bid = b.id
join ...
...
end