Dynamic T-SQL Script Parameterization Using Python

Question

Dynamic T-SQL Script Parameterization Using Python

omu

Old Hand

Points: 385
More actions
March 24, 2025 at 12:00 am

#4552900

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using Python

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004593 More actions · Answer 1

You can always tell when a new article is going to be popular when the SPAM hits the discussion on it two weeks prior to the date it's supposed to be published. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Alex Grasshopper Points: 14 More actions · Answer 2

Do we really need value parameter in build_dynamic_sql()?

It looks like passthrough parameter to me unless I miss something.

MMartin1 One Orange Chip Points: 27840 More actions · Answer 3

Nice illustration. If you could write or supply an introductory article on the basics on the pyodbc library I think others could also tinker for themselves the different things that Python can do with SQL.

I do wonder , how would a front end application make use of the library?

----------------------------------------------------