python #mssql #execute #module #example (1) 썸네일형 리스트형 [python][mssql] query module, example import pymssql def execute(query): conn = pymssql.connect(server='{{SERVER_IP}}', user='{{USER_ID}}', password='{{PASSWORD}}', database='{{DB_NAME}}', charset='utf8') cursor = conn.cursor(as_dict=True) result_data = [] if conn: cursor.execute(query) index = 0 for row in cursor: result_data.insert(index, row) index = index + 1 else: pass conn.close() conn = None return result_data sql = "SELECT *.. 이전 1 다음
