<p>sql语法中有几个错误,不需要额外的括号((“在执行联接时。您不必担心sql语句的缩进,但是python缩进和换行可能有点棘手。为了简化代码,您可以在python中使用多行字符串(即使用<code>""" some string """</code>)</p>
<pre class="lang-py prettyprint-override"><code>import pymssql
conn = pymssql.connect(server= 'xxx',
user= 'xxx',
password= 'xxx',
database= 'xxx'
)
cursor = conn.cursor()
sql = """
SELECT
PatientInfo.MRN,
AccountPersonalInfo.LastName,
Visit.VisitNumber,
PatientInfo.FirstName,
PatientInfo.LastName,
AccountPersonalInfo.FirstName,
Report.LastSignDate,
Orders.ProcedureDescList,
Visit.Facility,
Orders.CompleteDate,
Orders.FillerOrderNumber
FROM
Comm4.dbo.Order Orders
INNER JOIN
Comm4.dbo.Report Report ON Orders.ReportID=Report.ReportID
INNER JOIN
Comm4.dbo.Visit Visit ON Orders.VisitID=Visit.VisitID
INNER JOIN
Comm4.dbo.PatientInfo PatientInfo ON PatientInfo.PatientID=Visit.PatientID
INNER JOIN
Comm4.dbo.AccountPersonalInfo AccountPersonalInfo ON
Report.SignerAcctID=AccountPersonalInfo.AccountID
WHERE
PatientInfo.MRN<>'TEMPORARY' AND
Report.LastSignDate>={ts '2020-09-01 00:00:00'} AND
Report.LastSignDate<{ts '2020-10-01 00:00:00'}
ORDER BY
Report.LastSignDate, PatientInfo.MRN
"""
cursor.execute(sql)
row = cursor.fetchone()
conn.close()
print(row)
</code></pre>