SqlServer 示例:with as 递归查询、一行转多行
WITH Temp AS (
SELECT
1 AS XuHao,--初始序号为1
T1.Id
FROM U_SDP1 T1 WHERE T1.DocEntry = @DocEntry
UNION ALL
SELECT
Tm.XuHao+1 AS XuHao,--序号递增
T1.Id
FROM Temp Tm INNER JOIN U_SDP1 T1 WHERE Tm.I...
原创
2018-10-11 05:08:06 ·
1236 阅读 ·
0 评论