반응형

목록2025/09/24 (1)

DBILITY

pymssql을 사용한 SQL Server 접속 테스트

driver가 필요하니 pymssql installpip install pymssqldb_test.pyimport pymssqlserver = "localhost"user = "사용자"password = "비밀번호"database = "대상 데이터베이스명"try: conn = pymssql.connect(server=server, user=user, password=password, database=database) cursor = conn.cursor() sql = """ SELECT A, B, C, D FROM DUMMY_TABLE """ cursor.execute(sql) rows = cursor.fetchall() for row in rows: ..
python 2025. 9. 24. 10:57
Prev 1 Next
반응형