SQL流水号

--创建生成流水号的触发器

CREATE TRIGGER [dbo].[T_arDtl_INSERT] ON [dbo].[arDtl]

INSTEAD OF INSERT

AS

DECLARE @ID INT

SELECT * INTO #TB FROM inserted

 

SELECT @ID=max(RUID) FROM TEST 

if @ID is null

SET @ID=0

update #TB SET @ID=@ID+1,RUID=@ID WHERE RUID=0 OR RUID IS NULL

INSERT INTO TEST SELECT * FROM #tb