Auto Numbering - SQL

  • Thread starter Thread starter biz7
  • Start date Start date
B

biz7

What is the sql standard code for auto numbering line items using a
userstring? Thanks.

Ex.:

1.
2.
3.
etc...
 
biz7 said:
What is the sql standard code for auto numbering line items using a
userstring? Thanks.
Try microsoft.public.sqlserver.programming instead. Your question doesn't
appear to have anything to do with .NET.

Then again, it's hard to tell what your question *is*. Any of these things
might be related:

- IDENTITY columns: http://msdn.microsoft.com/library/ms186775
- ROW_NUMBER: http://msdn.microsoft.com/library/ms186734
- Sequence generation:
http://groups.google.com/group/micr...read/thread/54e0b6748f9d2b73/9f1ffbb2536be508
 
biz,

Auto numbering is not set by a user string as the subject of auto numbering
is an integer, can you explain this a little bit more.

The standard way of numbering his in by instance a datatable is

-1
-2
-3

etc.

Cor
 
Back
Top