wms / wms4_globalnancangkuangji · Files

import pymssql
conn = pymssql.connect(server='192.168.1.168', port=1433, database='wms4_global', user='sa', password='HHrobot123.')
cursor = conn.cursor(as_dict=True)
cursor.execute("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'receipt_container_header' ORDER BY ORDINAL_POSITION")
print('receipt_container_header columns:')
for r in cursor: print(' ', r['COLUMN_NAME'])
cursor.execute("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'receipt_container_detail' ORDER BY ORDINAL_POSITION")
print('receipt_container_detail columns:')
for r in cursor: print(' ', r['COLUMN_NAME'])
cursor.execute("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'receipt_header' ORDER BY ORDINAL_POSITION")
print('receipt_header columns:')
for r in cursor: print(' ', r['COLUMN_NAME'])
conn.close()