python #파이썬 #sp #stored procedure #create #구문가져오기 (1) 썸네일형 리스트형 [python] sp 명으로 sp create 구문 가져오기 파이썬 3.x + mssql import pymssql def execute(query): conn = pymssql.connect(server='{서버IP}', user='{아이디}', password='{패스워드}', database='{db명}', charset='utf8') cursor = conn.cursor(as_dict=True) result_data = [] if conn: # print('{서버IP} connected') cursor.execute(query) index = 0 for row in cursor: result_data.insert(index, row) index = index + 1 else: # print('{서버IP} connect error') pass conn.clo.. 이전 1 다음