pymssql, can't execute EXEC command sql

Question

i'm trying to execute this type of sql command with python but that doesn't work

import pymssql

_conn = pymssql.connect(** SQL parameter)
_cur = _conn.cursor()
_cur.execute("EXEC(SELECT * something)")

i got this error.

Thanks.

Did you try adding `_conn.commit()` after the line of `_cur.execute(...` ? — Szabolcs, Nov 16 '17 at 09:52

score 0 · Answer 1 · answered Nov 16 '17 at 09:56

0

The EXECUTE command takes a string, not plain SQL commands:

EXEC('SELECT * something')

But I'm not sure why you're doing this, you could just pass the SELECT statement directly.

answered Nov 16 '17 at 09:56

Daniel Roseman

Because i have to read an sql file that have this type of sql request – Antoine Galpin Nov 16 '17 at 09:58
I don't understand. Show the contents of that SQL file and the full code you're using to read it. – Daniel Roseman Nov 16 '17 at 10:01
See the next answer – Antoine Galpin Nov 16 '17 at 10:09

1 Answers1