27,579
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('sp_getjh') IS NOT NULL
DROP PROC sp_getjh
GO
CREATE PROC sp_getjh
@jh VARCHAR(30)
AS
SELECT LEFT(@jh,4)+RIGHT(1000+SUBSTRING(@jh,5,3)+1,3)
+'-'+RIGHT(@jh,CHARINDEX('-',REVERSE(@jh))-1) AS nextjh
GO
DECLARE @s VARCHAR(30)
SET @s='0909001-L'
EXEC sp_getjh @s
/*
nextjh
---------------------------------------------
0909002-L
(1 行受影响)
*/
SET @s='0909001-LR'
EXEC sp_getjh @s
/*
nextjh
---------------------------------------------
0909002-LR
(1 行受影响)
*/