想要将值增加1 [英] want to increment value by 1

问题描述

对于我的应用程序

我想插入一个10位数字作为SPLR000001

为此，我写了

选择``SPLR''+ LEFT(CONVERT(VARCHAR(6)，``000001'')，6)

但我想将000001的值增加为1，例如000002
000003
，
，

for my application

i want to insert a 10 digit number as SPLR000001

for this i have written

SELECT ''SPLR''+LEFT(CONVERT(VARCHAR(6),''000001''),6)

but i want to increment 000001 value to 1 like 000002
000003
,
,

how??

推荐答案

1.提取您的ID(您还可以创建一个Identity列并加以利用，以免手动增加.
2.生成您的唯一ID.

1. Fetch your Id(You can also create an Identity column and make use of it, so that avoid manual increment.
2. Genearate yr unique Id.

'SPLR' + RIGHT('00000' + CAST(Id AS NVARCHAR(10)),6)

看看这个线程(看解决方案3).这可能不是解决问题的方法，但却是您考虑的提示.
在sql中输入格式数据，如001,003,087,234 [ ^ ]

您可以使用标识(属性) [ ^ ].

这是示例代码

Take a look at this thread (look at Solution 3). This may not be a solution to your problem but its a tip for you to consider.
Enter formated data in sql like 001,003,087,234[^]

You can generate unique consecutive numbers in SQL server using IDENTITY (Property)[^].

Here is a sample code

CREATE TABLE #SampleTable
(
	ID INT Identity(1,1),
	Column1 VARCHAR(50)
)

INSERT INTO #SampleTable
SELECT 'Row 1' UNION
SELECT 'Row 2' 

SELECT *, 'SPLR' + REPLICATE('0', 6 - LEN(ID)) + CAST(ID AS VARCHAR) FROM #SampleTable

DROP TABLE #SampleTable

试试这个.

Hi,

try this.

DECLARE @ID INT = CAST(SUBSTRING('SPLR000001',5,10) AS INT)
SET @ID = @ID + 1
SELECT 'SPLR' + RIGHT(Replicate('0',6) + CAST(@ID AS VARCHAR),6)

希望它能起作用

Hope it works

这篇关于想要将值增加1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！