BC driver are doing with the SQL
> commands being passed to them.
>
>
>
> On Tue, Apr 7, 2020, at 3:12 PM, Iván Gómez Villafañe wrote:
>
> PS. errata, change var1/var2 for col1/col2..
>
> -- SQL START
>
> SET ANSI_WARNINGS OFF
>
> SELECT
> id_col,
&
avg_col2_neg) / @std_col2_neg AS col2_neg
INTO output_table
FROM output_table_temp;
DROP TABLE output_table_temp;
On Tuesday, 7 April 2020 16:09:10 UTC-3, Iván Gómez Villafañe wrote:
>
> Hi Mike, thanks for your reply.
>
> Regarding context, here's a sample sql with 2 c
tually executed" since there's not really
> any example or context provided here.
>
>
>
> On Tue, Apr 7, 2020, at 2:25 PM, Iván Gómez Villafañe wrote:
>
> I have my own tran() function, as the doc suggests:
>
> engine = sqlalchemy.create_engine(
> 'mssql+pyodbc:/
I have my own tran() function, as the doc suggests:
engine = sqlalchemy.create_engine(
'mssql+pyodbc://@SHINKEN/supervielle?trusted_connection=yes&driver=ODBC+Driver+13+for+SQL+Server'
, fast_executemany = True)
def tran(sql,engine):
with engine.begin() as conn:
conn.execute(sql)
I ex