thanks for all ur reply.It's not me that write the code.In fact ,the trigger may looks strange,the 20000 record table's DDL

<i>CREATE TABLE [dbo].[waitForDealTrans] (

[id] [bigint] IDENTITY (1, 1) NOT NULL...