Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - Auto Numbering - SQL

Reply
 
Old 04-19-2009   #1 (permalink)
biz7


 
 

Auto Numbering - SQL

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

Ex.:

1.
2.
3.
etc...

My System SpecsSystem Spec
Old 04-19-2009   #2 (permalink)
Jeroen Mostert


 
 

Re: Auto Numbering - SQL

biz7 wrote:
Quote:

> 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/micro...1ffbb2536be508

--
J.
My System SpecsSystem Spec
Old 04-19-2009   #3 (permalink)
Cor Ligthert[MVP]


 
 

Re: Auto Numbering - SQL

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

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Numbering Vista General
Sequential File Name Numbering Vista General
Word 2007 Automatic numbering for Table captions and Figure captio Vista General
Vista Device numbering issue Vista General
Photo numbering system in Vista Vista music pictures video


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46