如何找出3個表中都有的欄位名稱，比如TAB1,TAB2,TAB3
uj5u.com熱心網友回復：
sql下的常用系統表要熟悉，syscolumnsuj5u.com熱心網友回復：
SELECT a.name FROM sys.columns a INNER JOIN sys.objects b ON b.object_id = a.object_id
WHERE b.name IN ('TAB1','TAB2','TAB3')
GROUP BY a.name HAVING COUNT(1)=3
uj5u.com熱心網友回復：
CREATE TABLE #A(月份 VARCHAR(20),期初 int,入庫 int,出庫 int,結存 int)
INSERT INTO #A values('2020-01',0,18728,6195,12533)
INSERT INTO #A values('2020-02',12533,-434,11260,839)
CREATE TABLE #B(xxxx VARCHAR(20),xxx int,xx int,出庫 int,結存 int)
CREATE TABLE #C(aaaa VARCHAR(20),aaa int,入庫 int,aa int,結存 int)
select name from(
SELECT name,ROW_NUMBER() over(partition by name order by object_id) rownum
FROM tempdb.sys.columns WHERE object_id in (OBJECT_ID('tempdb..#A'),OBJECT_ID('tempdb..#B'),OBJECT_ID('tempdb..#C'))
)a where a.rownum=3
-----tempdb要換成資料庫名
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/232786.html
標籤：應用實例