Questions tagged [external-scripts]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
19 views

How to update data in mysql from csv /excel

I've table products. I need update column stock and sku with data from csv file. Screen from table: sample csv structure: Total is about 50K+ records. How can I update all in database?
  • 101
3 votes
2 answers
326 views

Nest a SQL file into another in SQL Server

I have a simple SQL file I'm using to perform some test: DECLARE @VAR1 AS VARCHAR(100) = '12345' DECLARE @VAR2 AS INTEGER = 54321 WAITFOR DELAY '00:00:02' INSERT Orders SELECT @VAR1 AS COL1, @...
  • 493
5 votes
1 answer
412 views

Why MS SQL bigint type is implicitly mapped to float64 python type, and what is the best way to handle it? [closed]

Python integer type has unlimited precision so it is more than capable to hold a bigint value of MS SQL (64 bit). Still it is implicitly mapped to float64 python type, when passed to an external ...
  • 335
3 votes
2 answers
296 views

Is using CLR for regular expressions safer than using external scripts?

Problem The main problem we need to use regular expression on MS SQL Server 2019, with the capability of at least the level on the POSIX Regular expression. Possible solutions This Q/A from ...
  • 335
0 votes
0 answers
328 views

Parallel execution of a SQL Server external script

TLDR for a reader with the same problem If your external script is too slow, you may do something in your scritpt which can be implemented in TSQL, which is a big problem. If this is not the case use ...
  • 335