//@RunningNo is in varchar(6) format
SET @RunningNo = SUBSTRING(@CaseNo,12,6)
SELECT @RunningNo AS runningNo1 //OUTPUT: 00099
SET @RunningNo = @RunningNo + 1
SELECT @RunningNo AS runningNo2 //OUTPUT: 100
我可以保留位数,以便第二个输出为000100
而不是100
吗?
//@RunningNo is in varchar(6) format
SET @RunningNo = SUBSTRING(@CaseNo,12,6)
SELECT @RunningNo AS runningNo1 //OUTPUT: 00099
SET @RunningNo = @RunningNo + 1
SELECT @RunningNo AS runningNo2 //OUTPUT: 100
我可以保留位数,以便第二个输出为000100
而不是100
吗?
这里最好的解决方案可能是将@RunningNo
声明为整数,然后在要以某种格式查看总计时使用FORMAT
:
DECLARE @RunningNo INT = 99;
SET @RunningNo = @RunningNo + 1
SELECT FORMAT(@RunningNo,'D6')