本文介绍了一个SQL过程，用于自动生成带有日期的记录控制(RC)编号。该过程通过递增整数并结合当前日期来创建唯一的RC编号。
drop proc GetRCId
go
create proc GetRCId(@int int)
as
begin
declare @next int
declare @id varchar(50)
declare @date varchar(50)
set @int=@int+1
set @date = Convert(varchar(50),getdate(),112)
set @next = 10000+@int
set @id = substring(cast(@next as varchar(5)),len(cast(@next as varchar(5)))-3,4)
set @id ='rc'+@date+@id
print @id
end
go
go
create proc GetRCId(@int int)
as
begin
declare @next int
declare @id varchar(50)
declare @date varchar(50)
set @int=@int+1
set @date = Convert(varchar(50),getdate(),112)
set @next = 10000+@int
set @id = substring(cast(@next as varchar(5)),len(cast(@next as varchar(5)))-3,4)
set @id ='rc'+@date+@id
print @id
end
go
exec GetRCID 3
扫一扫
401
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
