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

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

user specific auto generate code

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

user specific auto generate code

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us