user specific auto generate code

Question

0.00/5 (No votes)

See more: (untagged)

Dear i want to generate user specific auto increment code . like

i m creating a lead sheet . than when we submit and save it in database its id should be create like this : LS_001 for next entry . it should be , LS_002

Posted 27-Jan-14 3:11am

Rohit85

Add a Solution

2 solutions

Solution 1

can you please check it out this...

Auto-incremented ID with NVARCHAR/VARCHAR datatype[^]

you need to work around and need to change accordingly to your requirement.

Posted 27-Jan-14 3:20am

Tejas Vaishnav

Updated 27-Jan-14 3:21am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Karthik_Mahalingam · Accepted Answer · 2014-01-27T03:27:00

Solution 2

Try like this

SQL

CREATE      TABLE dbo.TestTable
( ID INT IDENTITY(1,1) PRIMARY KEY,
name int ,
  FormatColumn AS RIGHT('LS_00' + CAST(ID AS VARCHAR(8)), 6) PERSISTED
)

insert into TestTable ( name) values (1)
insert into TestTable ( name) values (2)
insert into TestTable ( name) values (3)

select * from TestTable

Posted 27-Jan-14 3:27am

Karthik_Mahalingam

Comments

Rohit85 28-Jan-14 2:23am

This Is Successfully Run .

Rohit85 28-Jan-14 5:02am

Karthik tell me one thing if i run this code to Ms Access Data base it will run with same code or i have to change some where