Sql Query or .net code

Question

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.

Pradip Pandey · Answer

Hi Use below code DECLARE @value1 VARCHAR(64)='BC10'; DECLARE @value2 varchar(2) SET @value2 = (select substring(@value112)) DECLARE @restvalue INT; SELECT @restvalue=(CAST(REPLACE(@value1'BC''') AS INT))+1; SELECT @value2 + cast(@restvalue as varchar) Hope it will help you.

Khan Abrar Ahmed · Answer

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