select a.name,count(1) from sys.columns a inner join sys.indexes b on a.object_id=b.object_id group by a.name having count(1)>1
有: --05 SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB1') INTERSECT SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB2')
--2KSELECT NAME FROM ( SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB1') UNION ALL SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB2') ) T GROUP BY NAME HAVING COUNT(1)=2
select a.name,count(1) from sys.columns a
inner join sys.indexes b
on a.object_id=b.object_id
group by a.name
having count(1)>1
--05
SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB1')
INTERSECT
SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB2')
FROM (
SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB1')
UNION ALL
SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB2')
) T
GROUP BY NAME
HAVING COUNT(1)=2
select a.name
from a,b
where a.name=b.name