SQL server 產生按日期排序的編號

 Declare @maxVersion int,@strYear varchar(2),@strMonth varchar(2),@strYearMonth varchar(4)
 Set @strYear  = Right(Cast(Datepart(yy,Getdate()) AS varchar(4)),2)
 Set @strMonth =  Cast(Datepart(mm,Getdate()) AS varchar(4))
 if (Len(@strMonth) = 1)
  Set @strMonth = '0' + @strMonth
  
 Set @strYearMonth = @strYear + @strMonth
 
 select @maxVersion = max(BomVersion) from TBL_Bom Where MaterialNo = @MaterialNo
  
 --當最大值無效,或當前月份有大於最大值月份時
 if (@maxVersion is null OR @maxVersion = 0 OR  Cast(@strYearMonth AS Int)  >  @maxVersion / 100) 
  set @BomNewVersion = Cast( (@strYearMonth + '01') AS int)
 else
  Set @BomNewVersion = @maxVersion + 1

三個SUBSTRING
Sql server 中 SELECT x = SUBSTRING('abcdef', 1,len('abcdef'))
c#  中：  string x = SUBSTRING('abcdef', 0,len('abcdef'))
javascript中：string x = SUBSTR('abcdef', 0,len('abcdef'))
稍微有點區別。