#/ Usr/bin/env Python
#Encoding: utf-8
"""
@Author: Frank @File: sqlserver. py
@Time: May 22, 2017
"""
Import pyodbc
Import pandas as PD Conn= Pyodbc. connect (' DRIVER= {SQL Server}; SERVER= 2001: da8:700e: e00: d129:18c: 5345:5a44; DATABASE= zc-nxjc-znc-znf_dcs02; UID= sa; PWD= 123456')
#Cur= Conn. cursor()
#Cur. execute (" select top 3 * from dbo. DCSContrast")
#ResList= Cur. fetchall() # fetchall() is to receive all the returned result rows
#If not cur:
#Raise (NameError," Database connection failed")
#Df= Pd.DataFrame (resList)
Df= Pd.read_SQL (select * from dbo. DCSContrast, con)
Df1; Pd.read_SQL (" select * from History-ProcessVariable01", con= conn)
Conn. close()
Print (df1)
#Encoding: utf-8
"""
@Author: Frank @File: sqlserver. py
@Time: May 22, 2017
"""
Import pyodbc
Import pandas as PD Conn= Pyodbc. connect (' DRIVER= {SQL Server}; SERVER= 2001: da8:700e: e00: d129:18c: 5345:5a44; DATABASE= zc-nxjc-znc-znf_dcs02; UID= sa; PWD= 123456')
#Cur= Conn. cursor()
#Cur. execute (" select top 3 * from dbo. DCSContrast")
#ResList= Cur. fetchall() # fetchall() is to receive all the returned result rows
#If not cur:
#Raise (NameError," Database connection failed")
#Df= Pd.DataFrame (resList)
Df= Pd.read_SQL (select * from dbo. DCSContrast, con)
Df1; Pd.read_SQL (" select * from History-ProcessVariable01", con= conn)
Conn. close()
Print (df1)