代码已经测试过了,成功!
import pymssql #引入pymssql模块
def conn():
ret = pymssql.connect(host='DESKTOP-4CDQOMR', user = 'sa', password = '123456') #服务器名,账户,密码
if ret:
print("连接到数据库成功!")
else:
print("连接到数据库失败!")
return ret
if __name__ == '__main__':
conn = conn()
if conn:
cursor = conn.cursor()
sql = "if not exists (select * from sys.databases where name = 'test14') begin create database test14 end"
conn.autocommit(True)
cursor.execute(sql)
conn.autocommit(False)
conn.close()