Scripts

In the world of SQL Server, adaptation is key. While the built-in GENERATE_SERIES() function was a valuable addition in SQL Server 2022, its absence in older versions created a functionality gap. Enter the user-written GENERATE_SERIES function. Adapted from Jeff Moden's "dbo.fnTally", it offers an efficient means to generate a series of numbers within a defined range in older SQL Server versions. Its design mirrors the built-in function in SQL Server 2022, making the transition between versions as simple as removing the dbo. prefix. This forward-thinking design reflects the ingenuity of the SQL Server community, ensuring a seamless, efficient database migration experience.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2023-06-26 (first published: 2023-06-16)

2,395 reads

Discuss

Simple script to de-identify data

by Stewart Campbell

SQLServerCentral

Auditing

An audit finding relating to production data, containing customer identifiable data, in a UAT environment, prompted this simple script, which completely scrambles data in such a way that the original value can not be reconstituted.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1 (2)

You rated this post out of 5. Change rating

2023-05-24 (first published: 2023-05-19)

840 reads

Discuss

Extract parts of the strings from the SQL results directly by using SQL's substring-extraction API functions

by Piyush Tripathi

SQLServerCentral

If you need to extract a substring or create a longer string by combining multiple strings, there are a few methods you can use. To extract a specific portion of a string, you can utilize a substring-extraction function.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2023-05-09 (first published: 2023-05-05)

299 reads

Discuss

Python 3 Script for Generating SQL Insert Statements from CSV Data

by Piyush Tripathi

SQLServerCentral

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2023-05-08 (first published: 2023-05-05)

5,293 reads

Discuss

Converting To/From User Friendly Trigesimal Geocodes

by Todd Owens

SQLServerCentral

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 […]