Click here to Skip to main content
12,956,606 members (70,743 online)
Rate this:
 
Please Sign up or sign in to vote.
I want to increment the Registration Id as
S0001 so how can I do with auto increment....
pls suggest me
Posted 28-Sep-12 23:14pm
Updated 29-Sep-12 5:42am
v2
Comments
Zoltán Zörgő 29-Sep-12 12:37pm
   
I would create add a .net integrated data type for the sql server, if this is acceptable in your environment. If you are interested in this path, I could guide you.

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Use a stored procedure instead of the INSERT statement.

An example is here: Auto-incremented ID with NVARCHAR/VARCHAR datatype[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,869
CHill60 3,550
Maciej Los 3,302
ppolymorphe 2,080
Jochen Arndt 1,973


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 29 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100