[SQL ] 流水編號重新計數

[yawhoami (zoor)]

DECLARE         @YEAR                   VARCHAR(4)
DECLARE         @MONTH                  VARCHAR(2)
DECLARE         @DATE                   VARCHAR(2)
DECLARE         @COUNT                  VARCHAR(4)
DECLARE         @DISSCU_NO              VARCHAR(12)


DECLARE         @MONTHS                 VARCHAR(2)
DECLARE         @DATES                  VARCHAR(2)
DECLARE         @COUNTS                 VARCHAR(4)


SET @YEAR = CONVERT(varchar, DATEPART(YYYY, GETDATE()))

SET @MONTHS = CONVERT(varchar, DATEPART(MM, GETDATE()))
        IF @MONTHS < 10
                BEGIN
                        SET @MONTH = '0' + @MONTHS
                END

SET @DATE = CONVERT(varchar, DATEPART(DD, GETDATE()))


SET @DATES = CONVERT(varchar, DATEPART(DD, GETDATE()))
        IF @DATES < 10
                BEGIN
                        SET @DATE = '0' + @DATES
                END

SET @COUNTS = (SELECT COUNT(*) FROM DISSCUSS)
SET @COUNTS = @COUNTS + 1

        IF @COUNTS < 1000
                BEGIN
                        SET @COUNT = '0' + @COUNTS
                END
        IF @COUNTS < 100
                BEGIN
                        SET @COUNT = '00' + @COUNTS
                END

        IF @COUNTS < 10
                BEGIN
                        SET @COUNT = '000' + @DATES
                END
SET @DISSCU_NO = @YEAR + @MONTH + @DATE + @COUNT

print@disscu_NO


以上是單純對DISSCU_NO產生yyyymmdd+後四碼的流水號

可是如果，我想要每過一天，流水編號就會自動歸零，重新從0001開始計算，請問我該怎麼改??



--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 122.116.115.219