每行增加一个 [英] Increment by one for each row
问题描述
我希望增加/增加给定序列号一个下一个EG''4''(我必须能够选择我想要的行数)行。
例如,如果数字是
ECR12345432123456543216则必须是以下数字
ECR12345432123456543217
ECR12345432123456543218
ECR12345432123456543219
给出的数字和序列号数量。
将有前三个字母,然后是20个数字。< br $>
i希望将序列号增加一个。
请帮忙。
使用下面的sql
声明 @ sNo varchar ( 23 )= ' ECR12345432123456543217';
选择 left ( @ sNo , 3 )+ convert ( varchar , convert ( decimal ( 20 ,< span class =code-digit> 0 ), right ( @ sNo ,< span class =code-digit> 20 ))+1)
您好,试试以下代码
声明@str varchar(25)
set @str ='''ECR12345432123456543216''
选择转换(十进制(25,0),子串(@ str,4,21))+ 1
尝试拆分字符串。一部分是''ECR''字符,另一部分是序列号123456 .....
然后增加数字部分并在完成时构造一个新字符串。
serialNumber + = 1;
或
serialNumber = serialNumber + 1;
string newStr = ercString + serialNumber;
我会告诉你如何拆分字符串。
i want to increment/ increase given serial number by one for next EG''4''(i must be able to chose number of rows i want) rows.
eg if number is
ECR12345432123456543216 then following number must be
ECR12345432123456543217
ECR12345432123456543218
ECR12345432123456543219
quantity of numbers and serial number are given.
there will be first three alphabet then 20 digits.
i want to increase serial number by one.
please need help.
Use below sql
declare @sNo varchar(23) = 'ECR12345432123456543217' ; select left(@sNo,3) + convert(varchar, convert (decimal(20,0) ,right(@sNo,20)) +1 )
Hello,Try Following code
declare @str varchar(25)
set @str=''ECR12345432123456543216''
Select Convert(decimal(25,0),Substring(@str,4,21))+1
Try split the string. One part is the ''ECR'' chars, the other is the serial number 123456.....
Then increment the number part and construct a new string when done.
serialNumber += 1; Or serialNumber = serialNumber + 1; string newStr = ercString + serialNumber;
I''ll let you figure how how to split the string.
这篇关于每行增加一个的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!