檢視表名與列名

SELECT 
a.name,
b.COLUMN_NAME,
'1' AS aflag
FROM sys.tables a
LEFT JOIN information_schema.columns b ON b.table_name=a.name AND b.COLUMN_NAME IN('scantime','時間','stime','time')

WHERE name LIKE 'PAR_%' AND a.name NOT LIKE '%_Removed' AND b.COLUMN_NAME IS NOT NULL      

NetAnalyzer下載下傳位址

NetAnalzyer交流群：39753670 （PS 隻提供交流平台，群主基本不說話^_^）

[轉載請保留作者資訊  作者：馮天文 ]