Loading

Sql Query or .net code

Sarath Kumar

12y1.6kSQL

Hi,

I have one transaction table. in that one OrderId column is there. for that column assign one default value like 'BC10'. I need to increment that OrderId value for every transaction. how can i write query for that or is there any possibility to increment that column value from aspx page. if anyone knows pleae help me......

Example: i have done first transaction, that OrderId is BC10. For next transaction OrderId is BC11.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradip Pandey12y ago
Hi
Use below code
DECLARE @value1 VARCHAR(64)='BC10';
DECLARE @value2 varchar(2)
SET @value2 = (select substring(@value1,1,2))
DECLARE @restvalue INT;
SELECT @restvalue=(CAST(REPLACE(@value1,'BC','') AS INT))+1;
SELECT @value2 + cast(@restvalue as varchar)

Hope it will help you.
0
Khan Abrar Ahmed12y ago
Hi you can try in SQL like that

DECLARE @value VARCHAR(64)='BC10';
DECLARE @addvalue INT;
SELECT @addvalue=(CAST(REPLACE(@value,'BC','') AS INT))+1;

SELECT @addvalue
0