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)

2006-05-17

9,010 reads

Blogs

Truncating very large transaction log in full recovery mode

By

While I always configure transaction log backups for every database in non-simple recovery model,...

Autonomous Driving Around London

By

There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server

By

It is common to see high worker count issue on the production server and...

Read the latest Blogs

Forums

Amazon Redshift Data warehouse setup and bring data from Apps to Data warehouse

By Sridevi Kakolu

We are setting up new data warehouse with Amazon Redshift and building integrations to...

Remove the Dynamic code from my SQL sproc

By GrassHopper

I have a stored procedure that was created to run dynamically.  Other than me...

predictive query plan

By Arsh

Dear Friends, Please advise if there is a way to get a query plan...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers