Dynamic T-SQL Script Parameterization Using Python

  • 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)

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

  • Do we really need value parameter in build_dynamic_sql()?

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

  • 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?

     

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

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

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