Python pymssql and dblib Examples - Revision history

PeterHarding: /* Using DBLIB */

2016-11-06T04:51:12Z

Using DBLIB

← Older revision		Revision as of 14:51, 6 November 2016
Line 46:		Line 46:
	dblib - derived from the origain Sybase mechanism - was used with MS SqlServer until SqlServer 2000 version. It has been replaced in subsequent releases.		dblib - derived from the origain Sybase mechanism - was used with MS SqlServer until SqlServer 2000 version. It has been replaced in subsequent releases.

	LoadRunner uses this method for it native access to SqlServer databases - which becomes problematic with ~~perfoprmance~~ testing modern SqlServer releases.		LoadRunner uses this method for it native access to SqlServer databases - which becomes problematic with performance testing modern SqlServer releases.

	<pre>		<pre>

PeterHarding: Pymssql Examples moved to Python pymssql and dblib Examples

2008-04-30T08:23:45Z

Pymssql Examples moved to Python pymssql and dblib Examples

← Older revision	Revision as of 18:23, 30 April 2008
(No difference)

PeterHarding at 08:23, 30 April 2008

2008-04-30T08:23:10Z

Show changes

PeterHarding: New page:

 import pymssql  con = pymssql.connect(host='192.168.13.122',user='sa',password='',database='tempdb') cur = con.cursor()   query="create table pymssql (no int, fno float, comment va...

2008-04-30T08:19:37Z

New page: <pre> import pymssql con = pymssql.connect(host='192.168.13.122',user='sa',password='',database='tempdb') cur = con.cursor() query="create table pymssql (no int, fno float, comment va...

New page

<pre>
import pymssql

con = pymssql.connect(host='192.168.13.122',user='sa',password='',database='tempdb')
cur = con.cursor()

query="create table pymssql (no int, fno float, comment varchar(50));"
cur.execute(query)
print "create table: %d" % cur.rowcount

for x in range(10):
query="insert into pymssql (no,fno,comment) values (%d,%d.%d,'%dth comment');" % (x+1,x+1,x+1,x+1)
ret=cur.execute(query)
print "insert table: %d" % cur.rowcount

for x in range(10):
query="update pymssql set comment='%dth hahaha.' where no = %d" % (x+1,x+1)
ret=cur.execute(query)
print "update table: %d" % cur.rowcount

query="EXEC sp_tables; select * from pymssql;"
for x in range(10):
cur.execute(query)

while 1:
print cur.fetchall()
if 0 == cur.nextset():
break

query="drop table pymssql;"
cur.execute(query)
print "drop table: %d" % cur.rowcount

con.commit()
con.close()
</pre>

[[Category:Python]]
[[Category:Database]]