Python 3.9.7 (tags/v3.9.7:1016ef3, Aug 30 2021, 20:19:38) [MSC v.1929 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>>

exec xp_msver 

#pip 安裝pymssql (python3.6以上直接安裝不上)
pip install pymssql

#在官網(wǎng)下載pymssql對(duì)應(yīng)版本，在當(dāng)前文件夾下
https://pypi.org/project/pymssql/
pip install pymssql-2.2.4-cp39-cp39-win_amd64.whl

#coding=utf-8  #settng設(shè)置全局為utf—8格式
#導(dǎo)包
import pymssql
#創(chuàng)建連接字符串  （sqlserver默認(rèn)端口為1433）
conn =pymssql.connect(host='localhost', #這里的host='_'可以用本機(jī)ip或ip+端口號(hào)
                         server="******",#本地服務(wù)器
                         port="1433",#TCP端口
                         user="sa",password="******",
                         database="******",
                         charset="GBK"
#這里設(shè)置全局的GBK，如果設(shè)置的是UTF—8需要將數(shù)據(jù)庫(kù)默認(rèn)的GBK轉(zhuǎn)化成UTF-8    
    )
if conn:
   print('連接數(shù)據(jù)庫(kù)成功!')#測(cè)試是否連接上

#查詢(xún)語(yǔ)句
cursor =conn.cursor()  #使用cursor()方法獲取操作游標(biāo)
sql_select="SELECT * FROM STUDENT"  #數(shù)據(jù)庫(kù)查詢(xún)語(yǔ)句
cursor.execute(sql_select) #執(zhí)行語(yǔ)句
results =cursor.fetchall() #獲取所有記錄列表
#print('原始:',end="")
#print(result)   #后邊有空格

for result in results:
    result= list(result) #元組轉(zhuǎn)化為列表
    for res in range (len(result)):
        if isinstance(result[res],str):
            result[res]=result[res].replace(' ','')解決空格問(wèn)題
    result=tuple(result) #列表再轉(zhuǎn)換為元組
    print("處理后：",end="")
    print(result)
#
conn.commit()
#關(guān)閉數(shù)據(jù)庫(kù)
conn.close()

#插入語(yǔ)句
cursor =conn.cursor()
sql_insert="insert into student values(990031,'wang',20,'男','bb','aa')"
cursor.execute(sql_insert)
conn.commit()
conn.close()

#更新語(yǔ)句
cursor =conn.cursor()
sql_update="update student set AGE=21 where SNO='990031' "
cursor.execute(sql_update)
conn.commit()
conn.close()

#刪除語(yǔ)句
cursor =conn.cursor()
sql_delete="delete from student where sno='990031'"
cursor.execute(sql_delete)
conn.commit()
conn.close()

#新建表
cursor =conn.cursor()
sql_create="""create table table_student(SNO int primary key not null,SNAME varchar(100),SDEPT varchar(100),BPLACE varchar(100))"""
cursor.execute(sql_create)
conn.commit()
conn.close()

select COLLATIONPROPERTY('chinese_PRC_Stroke_CI_AI_KS_WS','CodePage')