Python 連接MS sql server2005數據庫

pymssql 是Python語言用來連接微軟 SQL SERVER 數據庫的類庫，實現了 Python DB API 2.0 。

項目地址：https://code.google.com/p/pymssql/

看來段代碼

    import pymssql

    conn = pymssql.connect(host='192.168.1.1',port='1433', user='user', password='password', database='mydatabase', as_dict=True)

    cur = conn.cursor()


cur.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')  
for row in cur:  
    print "ID=%d, Name=%s" % (row['id'], row['name'])  

conn.close()  </pre>第一行導入<p></p>

第二個連接ip為192.168.1.1端口為1433的mydatabase數據庫

第四行就是查詢表

下面就是遍歷表里面的數據很簡單吧。
調用存儲過程
    import pymssql

    conn = pymssql.connect(host='192.168.1.1','1433', user='user', password='password', database='mydatabase', as_dict=True)

    cur = conn.cursor()


cur.callproc('findPerson', ('John Doe',))  
for row in cur:  
    print "ID=%d, Name=%s" % (row['id'], row['name'])  

conn.close()  </pre></span></strong><strong><span style="font-size:14px;">創建表<pre class="brush:python; toolbar: true; auto-links: false;">    import pymssql  
conn = pymssql.connect(host='SQL01', user='user', password='password', database='mydatabase')  
cur = conn.cursor()  
cur.execute('CREATE TABLE persons(id INT, name VARCHAR(100))')  
cur.executemany("INSERT INTO persons VALUES(%d, %s)", \  
    [ (1, 'John Doe'), (2, 'Jane Doe') ])  
conn.commit()  # you must call commit() to persist your data if you don't set autocommit to True  

cur.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')  
row = cur.fetchone()  
while row:  
    print "ID=%d, Name=%s" % (row[0], row[1])  
    row = cur.fetchone()  

# if you call execute() with one argument, you can use % sign as usual  
# (it loses its special meaning).  
cur.execute("SELECT * FROM persons WHERE salesrep LIKE 'J%'")  

conn.close()  </pre></span></strong> <p></p>

來自：http://blog.csdn.net/wiker_yong/article/details/10208837