SQL Server Azure Data Studio use SQL parameters

pw9qyyiw 于 2023-08-02 发布在其他

关注(0)|答案(1)|浏览(105)

Is it possible to use SQL parameter markers by specifying the parameter somewhere in Azure Data Studio?

For example, a query query.sql like

SELECT * FROM table WHERE foo = ?

and having the parameter specified somewhere outside the query when run (for example with pyodbc this would be something like pd.read_sql(query, conn, params=["param"]) ).

Unlike Azure Data Studio - Setting SQL variables to be used as globals , I don't need a T-SQL global variable.

sql-server

来源：https://stackoverflow.com/questions/76757440/azure-data-studio-use-sql-parameters

1条答案

按热度按时间

0g0grzrc1#

You can use SQL parameter markers by fetching the parameters from notebook is possible by using following code:

query = "SELECT * from members WHERE Age = ? and Salary < ? "
Age = <value>
Salary = <value>
data_df = pd.read_sql_query(query, engine, params=(Age,Salary))

Output:

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server Azure Data Studio use SQL parameters

1条答案

相关问题

热门标签

最新问答