This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.
2023-05-08 (first published: 2023-05-05)
5,905 reads
The Problem As a data professional, I have often wished that there was a short, simple, and universal code to enable finding a place on earth. Addresses are nice but require a government authority to build a road, name it, and number its locations, and standardize its entry / use, and then they are far […]
2023-03-30 (first published: 2023-03-23)
217 reads
2023-02-22 (first published: 2023-02-14)
636 reads
A quick script that removes leading zeros in a numeric stored as a string.
2022-12-30 (first published: 2022-12-26)
2,684 reads
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2022-12-19 (first published: 2021-03-05)
457 reads
Simplified latitude / longitude in 10 fixed bytes.
2022-10-26 (first published: 2022-10-21)
621 reads
2022-09-02 (first published: 2022-08-23)
11,241 reads
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
2022-04-06 (first published: 2022-03-29)
994 reads
A stored procedure to search database objects (triggers, scalar functions, table valued functions, views and stored procedures) for a user defined string.
2022-04-04 (first published: 2022-03-28)
1,076 reads
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,948 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
CSO 08218200233 Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec....
CSO 08218200203 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi,...
CSO 08218200174 Jl. Gatot Subroto No.42 Suite G02, RT.3/RW.2, Kuningan Bar., Kec. Mampang Prpt.,...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers