document

Technical Article

RE: Including Sl.No column with the record set

  • Reply

Does your S.No column correspond directly to the empno (1, 1001; 2, 1002...)?If not, you probably want an identity column which will automatically increment.  Otherwise, you could use substring to pull the last digit from empno.  By the way, I wouldn't name the new column "S.No", "S_No" would be better.  Stuff like spaces, periods, quote marks, etc can cause […]

You rated this post out of 5. Change rating

2004-07-28

Blogs

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

The Future of the Social Web Is in Good Hands

By

The Social Web Foundation is aiming to grow the fediverse and make the social...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers