擅长:python、mysql、java
<p>我建议您在从python(如客户端)进行查询时最好使用一个过程,例如:</p>
<pre><code> Python
sqlExecSP="""\
EXEC [dbo].[NameProcedure] @p1 = ?;
"""
params = (p1)
cursor.execute(sqlExecSP, params)
SQL
CREATE PROCEDURE dbo.NameProcedure @p1 varchar(30)
AS
SELECT Top 1 Colum1,Column2
FROM MyTable
WHERE Colum1 Like '' + @p1 + '%';
GO
</code></pre>