Alter database query with variables using Python

Question

I am trying to execute below SQL query by introducing 2 variables in Python but getting error,

Original Query:

ALTER DATABASE db1 MODIFY (SERVICE_OBJECTIVE = 'DW300');

I want to use variables for db1 and 'DW300'. I have tried below statement in Python and got error.

dwu = 'DW100'
sqlpool = 'db1'
cursor.execute("""ALTER DATABASE ? MODIFY (SERVICE_OBJECTIVE = ?) """, (sqlpool, dwu))

Error: pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '@P1'. (102) (SQLExecDirectW)")

Farid Fakhry · Accepted Answer · 2022-07-28 15:53:17Z

1

I use sqlite and it accepts this answe.

try the use of fstrings

f"""Alter Database {sqlpool} modify (service objective = {dwu}) """

answered Jul 28, 2022 at 15:53

Farid Fakhry

3641 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Alter database query with variables using Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related