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,018 reads

Blogs

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

Read the latest Blogs

Forums

Sporadic error during restore job

By webrunner

Hello experts, I see this error in a SQL Agent job. It happens during...

Average price calculation

By Puiu

Hello! I need to make a query that will calculate my average price for...

Be Careful with Missing Index Requests

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Be Careful with Missing Index...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers