sqlserver2005流水号（编号结果类似：CS2011081200001）

发布时间：2020-12-12 14:57:38 所属栏目：MsSql教程来源：网络整理

导读：?CREATE function [dbo].[f_getNum](@title nvarchar(3),@date nvarchar(8)) ?returns nvarchar(50) as begin declare @str nvarchar(50) declare @tempDate nvarchar(8) declare @num nvarchar(5) declare @temp nvarchar(50) set @tempDate='' set @num=''

?CREATE function [dbo].[f_getNum](@title nvarchar(3),@date nvarchar(8))
?returns nvarchar(50)
as
begin
declare @str nvarchar(50)
declare @tempDate nvarchar(8)
declare @num nvarchar(5)
declare @temp nvarchar(50)
set @tempDate=''
set @num=''
declare @currentDate datetime
select @currentDate=max(create_date) from b
select @temp=max(num) from b where create_date=@currentDate ?if(@temp<>'') ??begin ????????? set @tempDate=substring(@temp,4,8) ?????????? if @tempDate=@date ???????????? begin ??????????? --当天 ??????????? set @num=right('00000'+cast((cast(right(@temp,5) as int)+1) as nvarchar(20)),5) ???set @str=@title+@tempDate+@num ??????????? end ?????????? else ??????????? begin ???--非当天 ??? set @str=@title+@date+'00001' ??????????? end ??end ?else ??begin ??? set @str=@title+@date+'00001' ??end return @str end

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!