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
-- When the maximum value is invalid or the current month has a month greater than the maximum value
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
Three substrings
In SQL server, SELECT x = SUBSTRING ('abcdef', 1, len ('abcdef '))
C #: string x = SUBSTRING ('abcdef', 0, len ('abcdef '))
In javascript: string x = SUBSTR ('abcdef', 0, len ('abcdef '))
A little different.