34,593
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE Test(ID int IDENTITY(1,1),Nr varchar(20))
GO
CREATE TRIGGER tr_cTest ON Test
FOR INSERT
AS
SET NOCOUNT ON;
BEGIN
UPDATE t SET Nr=CONVERT(varchar(8),GETDATE(),112)+RIGHT(1000000+i.ID,6) FROM inserted AS i INNER JOIN Test AS t ON i.ID=t.ID
END
GO
INSERT Test SELECT 1
GO 2
SELECT * FROM Test
/*
ID Nr
1 20160815000001
2 20160815000002
*/
DROP TABLE Test