给出下表:
CREATE TABLE #TestTable
(
Code varchar(10) NOT NULL,
Parent varchar(10) NULL
);
INSERT INTO #TestTable
SELECT 'Parent', Null UNION ALL
SELECT 'Child', 'Parent';我希望能够将以下内容转换为:
SELECT *
FROM #TestTable child
INNER JOIN #TestTable parent ON ( parent.Code = child.Parent );如下所示:
SELECT child.Code, child.Parent, parent.Code, parent.Parent
FROM #TestTable child
INNER JOIN #TestTable parent ON ( parent.Code = child.Parent );使用sp_describe_first_result_set时,我可以使用下面的语句来接近:
EXEC sp_describe_first_result_set
N'SELECT *
FROM #TestTable child
INNER JOIN #TestTable parent ON ( parent.Code = child.Parent )', NULL, 2;但它将以#TestTable而不是child/parent的形式返回源表。
发布于 2020-03-19 22:19:51
如果您唯一关心的是查看哪个表是源表,那么您可以将数据拆分为两个临时表,这样就会影响系统存储过程调用返回的source_table。
CREATE TABLE #TestTable
(
Code varchar(10) NOT NULL,
Parent varchar(10) NULL
);
INSERT INTO #TestTable
SELECT 'Parent', Null UNION ALL
SELECT 'Child', 'Parent';
select * into #Parent from #TestTable where code='Parent';
select * into #Child from #TestTable where Code='Child';
EXEC sp_describe_first_result_set
N'SELECT *
FROM #Child child
INNER JOIN #Parent parent ON ( parent.Code = child.Parent )', NULL, 2;
drop table #TestTable, #Parent, #Child;

https://stackoverflow.com/questions/60754006
复制相似问题