import pyodbc import pandas as pd from datetime import datetime
# datetime object containing current date and time
now = datetime.now()
cnxn = pyodbc.connect(driver='{SQL Server}',server='DBServerName',database='DB',trusted_connection='yes')
cursor = cnxn.cursor()
sql = "EXEC sp_who2"
data = pd.read_sql(sql,cnxn)
data[13]=now
print(data)
SQL Server Analytics Service 1
SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)
Max Chen (159)