python连接mssql执行存储过程

import pymssql

import sys

#conn = pymssql.connect(server, user, password, database)

server = "127.0.0.1" # 连接服务器地址

user = "sa" # 连接帐号

password = "#sql" # 连接密码

try:

conn = pymssql.connect(server, user, password, "test01") #获取连接

if conn:

print("连接成功!")

except:

print("连接出错！请检查！")

conn.close

sys.exit()

#

cursor = conn.cursor()

cursor.execute(f"exec 存储过程名称 @参数1='xxx',@参数2='xxx',@参数3='xxx',@参数4='xxx'")

result = cursor.fetchall() #得到结果集

for i in result:

print(i) #遍历打印查询结果集的数据

sql = """INSERT INTO [数据库].[文件名].[表名] ([column1],[column2],[column3],[column4]...)

VALUES({value1},{value2},'{value3}',{value4}...);

""".format(

value1=参数1,

value2=参数2,

value3=参数3,

value4=参数3,

...)

cursor.execute(sql)

conn.commit()

conn.close()