python3 连接SQLServer数据库代码示例

# -*- coding: UTF-8 -*-
import pymssql


def db_conn():
    connect = pymssql.connect('ip地址', '用户名', '用户密码', '数据库名') 
    if connect:
        print("1、连接数据库成功!")
    return connect


if __name__ == '__main__':
    db = db_conn()

    cursor = db.cursor()  # 创建一个游标对象,python里的sql语句都要通过cursor来执行
    # SQL 查询语句

    # sqlserver 版本太低
    create_sql = """
    IF OBJECT_ID(N'TR_TAC_TERM_5G_TMP', N'U') IS  NOT  NULL
    drop table TR_TAC_TERM_5G_TMP;
    create table TR_TAC_TERM_5G_TMP(
    品牌 varchar(20),
    型号 varchar(50),
    TAC varchar(20),
    终端类型 varchar(20)
    );
    """
    
    # 高版本可用 drop table if EXISTS TR_TAC_TERM_5G_TMP;

    insert_sql = """
    insert into TR_TAC_TERM_5G
    select 品牌,型号,TAC,终端类型 from TR_TAC_TERM_5G_TMP
    where TAC not in (select TAC from TR_TAC_TERM_5G);
    """

    count_sql =