We help IT Professionals succeed at work.

SQL Query - auto increment

holemania
holemania asked
on
Medium Priority
539 Views
Last Modified: 2012-05-11
Hello experts,

I need to generate a number that is auto increment by 10.  Not sure how to do this.

Example:

10    Bob Anderson
20    Jason Souler
30    Deb Kyle
40    Thomas Jaeger
Comment
Watch Question

Roman GhermanSenior Software Engineer

Commented:
You can set the identity increment  to 10, see screenshot AutoIncrement10

Author

Commented:
I'm doing a select from.  I need to increment a value that doesn't exists in the table.  
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Awesome.  Thank you.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.