Click here to Skip to main content
15,878,430 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
how to generate auto increment column value in stored procedure and passing the parameter to the like('A',string length,table name,table id) from the front end and generate A000,A001,A002, that ,if we change front end parameter (B,4,tname,idname) it generate like B000,B001,B002, that ( send the code to perform this in stored procedure)
Updated 25-May-11 1:48am
ZeeroC00l 25-May-11 7:49am    
-- edited for typo
Manfred Rudolf Bihy 25-May-11 8:46am    
"Send the code ..."

This great article should give you a couple of ideas:[^].


Share this answer
To generate auto increment column you can simply use the RANK methods available in SQL Server,
i believe ROW_NUMBER (Transact-SQL) rank methods will help you in this case to generate auto number column.

Link: ROW_NUMBER (Transact-SQL)

The Recursive Queries also give you an option to loop with in the rowset and generate auto increment column.

Link: Recursive Queries Using Common Table Expressions
Share this answer
RaviRanjanKr 27-May-11 7:50am    
Nice Answer, My 5 :)

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900