- <pre code_snippet_id="174162" snippet_file_name="blog_20140128_1_2023225" name="code" class="python">#encoding:utf-8
- import pymssql
- # 需要用到pymssql组件 该组件下载地址:http://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql
- conn = pymssql.connect(host="127.0.0.1",user="sa",password="123",database="Northwind")
- #需要用到端口号时
- # conn = pymssql.connect(host="127.0.0.1",port="端口号",user="sa",password="123",database="Northwind")
- #获取游标对象
- cur=conn.cursor()
- # #查询操作
- sql="SELECT TOP 1000\
- [RegionID] ,\
- [RegionDescription]\
- FROM [Northwind].[dbo].[Region] \
- ORDER BY [RegionID] DESC"
- cur.execute(sql)
- list=cur.fetchall()
- for data in list:
- print data[0],data[1]
- if len(list)>0:
- maxid = list[0][0]
- # #播入一条sql语句
- sql="INSERT INTO [Northwind].[dbo].[Region]\
- ([RegionID]\
- ,[RegionDescription])\
- VALUES\
- ("+str(maxid+1)+"\
- ,'test')"
- # #执行插入
- cur.execute(sql)
- # #提交事务,不执行提交,数据插入不会生效
- conn.commit()
- # #关闭数据库连接
- conn.close()
- # #暂停
- # raw_input()
- </pre><br>
- <br>
- <pre></pre>
原地址:
http://blog.csdn.net/wanzhuan2010/article/details/18844789