Asif Sayed


SQLServerCentral Article

Generating a Sequential Pattern

For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence.

2.5 (2)

You rated this post out of 5. Change rating

2006-05-17

9,022 reads

Blogs

A New Word: Apolytus

By

apolytus– n. the moment you realize you are changing as a person, finally outgrowing...

Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts

By

If you've ever wrestled with complex SQL code, you know the drill. Hours spent...

Check your regions people

By

Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...

Read the latest Blogs

Forums

Table Partitioning - remove null range

By goher2000

hi guys,   I have a partitioned table AM_ITM_INSTNC_MSS and I want to  get...

Principal owns a service?

By Brandie Tarvin

This is one I haven't seen before. I'm trying to drop a database user...

Issues backing up Analysis Services databases - silent failures

By Pete Bishop

I have a PowerShell script that I use to automate the backup of Analysis...

Visit the forum

Question of the Day

Read Only Replica in SQL Server Standard

Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?

See possible answers