Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymssql
- ip = '167.114.136.105'
- database_connection = pymssql.connect(host=ip, port=1433, user='fusezedc', password='.Towhitch01', database='fusezedc_koc-scripts')
- cursor = conn.cursor()
- cursor.execute("""
- IF OBJECT_ID('persons', 'U') IS NOT NULL
- DROP TABLE persons
- CREATE TABLE persons (
- id INT NOT NULL,
- name VARCHAR(100),
- salesrep VARCHAR(100),
- PRIMARY KEY(id)
- )
- """)
- cursor.executemany(
- "INSERT INTO persons VALUES (%d, %s, %s)",
- [(1, 'John Smith', 'John Doe'),
- (2, 'Jane Doe', 'Joe Dog'),
- (3, 'Mike T.', 'Sarah H.')])
- # you must call commit() to persist your data if you don't set autocommit to True
- conn.commit()
- cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')
- row = cursor.fetchone()
- while row:
- print("ID=%d, Name=%s" % (row[0], row[1]))
- row = cursor.fetchone()
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement