SQL流水号
摘要:
--创建生成流水号的触发器CREATE TRIGGER [dbo].[T_arDtl_INSERT] ON [dbo].[arDtl]INSTEAD OF INSERTASDECLARE @ID INTSELECT * INTO #TB FROM insertedSELECT @ID=max(RUID) FROM TESTif @ID is null SET @ID=0update #TB SET @ID=@ID+1,RUID=@ID WHERE RUID=0 OR RUID IS NULLINSERT INTO TEST SELECT * FROM #tb 阅读全文
posted @ 2011-12-07 16:33 笑看风云淡 阅读(243) 评论(0) 推荐(0) 编辑