ALTER PROCEDURE get_vip_archives_idcode
AS
/*
CREATE TABLE [dbo].[idcode_vip_archives] (
[code] varchar(200) COLLATE Chinese_PRC_CI_AS NULL ,
[ctime] datetime NULL DEFAULT (getdate()) ,
[cid] bigint NOT NULL IDENTITY(1,1) ,
CONSTRAINT [PK__idcode_v__D837D05F12765016] PRIMARY KEY ([cid])
)
exec get_vip_archives_idcode
*/
BEGIN
DECLARE @DATE DATETIME
DECLARE @YYYY VARCHAR(4)
DECLARE @MM VARCHAR(2)
DECLARE @DD VARCHAR(2)
DECLARE @D1 VARCHAR(2)
DECLARE @D2 VARCHAR(2)
DECLARE @D3 VARCHAR(2)
DECLARE @NEW_ID VARCHAR(200)
--保存取得的当前时间
SET @DATE = GETDATE()
SET @YYYY = DATEPART(yyyy, @DATE)
SET @MM = DATEPART(mm, @DATE)
SET @DD
SqlServer自定义存储日期自增长序列生成
最新推荐文章于 2024-07-10 16:50:41 发布