What are the challenges you face when working across database platforms? Take the survey
Options

Python with SQL

tilo23tilo23 Posts: 27
Is there any module associated (like sqlite3) which would allow the Python script to connect to the database? (I'm not a Python Pro - have just made some research regarding Python usage with SQL queries).
I would like to use Python scripts to make calculations on columns.
Inside the Dilbert's world

Comments

  • Options
    The latest version of SQL Data Generator allows you to use Python scripts to generate data for your columns. Simply select the Python generator for the column in question, then write your code.

    We have a guide and some examples here
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.