954,517 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

How to auto increment reference number with char(9)?

Hi, i'm a new programmer and i'm learning VS 2005 VB by myself and I've loads of questions to ask.

My question is to how to auto increment my reference number with char(9). I'm creating a web request form where users will enter all their information on the form and when they click save all data will be stored in a database. I realized that I can't use IDENTITY in my stored procedure to auto increment my reference number.What other ways can I use?

Please help.:cry:

shawn mohan
Newbie Poster
1 post since Jun 2006
Reputation Points: 10
Solved Threads: 0
 

I will try to help u out. Just mail me at [email]coolamit0072003@hotmail.com[/email]

Amit007
Newbie Poster
22 posts since Aug 2006
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You