FilesExpand file tree

 master

/

pymssql_connection.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

14 lines (10 loc) · 371 Bytes

 master

/

pymssql_connection.py

Copy path

Top

File metadata and controls

• Code
• Blame

14 lines (10 loc) · 371 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

#!/usr/bin/env python

# -*- coding: utf-8 -*-

import pymssql

conn = pymssql.connect(host='192.168.1.114', port='1433', user='sa', \

password='Agtech123', database='test', as_dict=True)

cur = conn.cursor()

cur.execute('SELECT * FROM namelist WHERE id=%s', '002')

for row in cur:

print "ID=%d, Name=%s" % (row['id'], row['name'])

conn.close()