Pages

Sunday, February 24, 2013

Select kolom dari table MS SQL Server


Rumus :
SELECT COLUMN_NAME 'Column' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Nama_Table'


Contoh :


SELECT COLUMN_NAME 'Column' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TMM_MoldDie'

No comments:

Post a Comment