MSSQL_串SCHEMA欄位

  • 1301
  • 0
  • 2012-02-09

摘要:INFORMATION_SCHEMA.COLUMNS

 

SELECT COLUMN_NAME + ' , '
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='WS_Event_Anniversary_TransferLog'
ORDER BY ORDINAL_POSITION