如何将 cte 的结果插入到表变量中
像这样的东西吗?
DECLARE
@myData TABLE(
Title nvarchar(350) NOT NULL ,
Id int NOT NULL ,
);
INSERT INTO @myData
with CTE as
(SELECT
a.Title
,a.Id
FROM
TableA
)
,CTE2 as
(SELECT
b.Title
,b.Id
FROM
TableB
)
Select * From CTE
union all
Select * From CTE2
Select ROW_NUMBER() OVER(ORDER BY GetDate() DESC) AS RowId
, x.*
From @myData x
order by x.Id desc
Try this
with CTE as
(SELECT
a.Title
,a.Id
FROM
TableA
)
,CTE2 as
(SELECT
b.Title
,b.Id
FROM
TableB
)
INSERT INTO @myData --- insert statement goes here after CTE
Select * From CTE
union all
Select * From CTE2
Select ROW_NUMBER() OVER(ORDER BY GetDate() DESC) AS RowId, x.*
From @myData x
order by x.Id desc
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)