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)

You rated this post out of 5. Change rating

2006-05-17

9,053 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Pejaten,Telp/Wa 0821.3111.159

By gopalchettri

Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F & 98G,...

BCA KCP Mayestik,Telp/Wa 0821.3111.159

By gopalchettri

Jl. Kyai Maja No.77, Gunung, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...

BCA KCP Plaza Sentral,Telp/Wa 0821.3111.159

By gopalchettri

Jl. Jend. Sudirman No.Kav.47, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah Khusus Ibukota...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers