GENERATE_SERIES()

Technical Article

The Power of Generate_series

  • Article

SQL 2022 introduced the function generate_series which permits us to solve problems for which we previously had to use a table of numbers (also known as a "tally table"). generate_series is a great addition, because when using a table of numbers there was always a risk that you could run out of numbers. Or some joker could have deleted rows from the table. All these worries are gone with generate_series.

You rated this post out of 5. Change rating

2025-03-05

SQLServerCentral Article

GENERATE_SERIES() Breaks Minimal Logging

  • Article

tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]

5 (9)

You rated this post out of 5. Change rating

2023-09-18

3,843 reads

Blogs

The Third Sabbatical

By

I can’t believe I’ve been at Redgate long enough to get a third sabbatical....

Advice I Like: Focus on what’s important

By

Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...

Is Air Travel Still Safe? | Ahmedabad Plane Crash 2025 Explained | Aviation Safety & AI Solutions

By

Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In...

Read the latest Blogs

Forums

200 hours YTT in Rishikesh

By prathamyoga7

Embarking on a 200 hours YTT in Rishikesh is a transformative journey that goes...

Azure Database Watcher Monitoring

By bokswager

Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...

Can You Ask for a Raise?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can You Ask for a...

Visit the forum

Question of the Day

Generating a Series I

What is returned by this code in SQL Server 2022?

SELECT value
FROM GENERATE_SERIES(4, 1);

See possible answers