Adding of a row with Default fields

9 views
Skip to first unread message

Lev Zlotin

unread,
Dec 17, 2018, 7:37:19 AM12/17/18
to pyodbc
Hi,
I have a query adding few( many) rows simultaneously using the cursor.execute( string, list)
INSERT INTO dev.test_basic_table ([TestId],[SubTestId],[Value]) VALUES  (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?)
after which following a list with multiple rows. I need that part of the fields will have the DEFAULT value, but I cannot find how to insert default values using this format of execute. Can you please help?
Reply all
Reply to author
Forward
0 new messages