彻底解决Ms sql server 2000中的最大流水号的生成问题

 

取得流水号的逻辑如下：

1.

Declare @myTradeID Int

Set @myTradeId = 0

/*现在Max_Trade_ID表中取得流水号的当前值：*/

Begin Transaction

Select @ymTradeId = ID +1 From Max_Trade_Id (tablockx)

Update Max_trade_Id Set id = Id + 1

Commit transaction

 

2.

/建立tradeInfo表和相关索引，/

Create table tradeInfo(Trade_ID Int identity (1,1), Tdtime datetime,TDnameVarchar(20))

Create index idx_trade_Id on tradeinfo (trade_ID)

 

Declaere @mytradeId Int

Set @mytradeId = 0

Begin Transcation

	Insert into tradeinfo values(Getdate(),'test'
	Select @myTradeID = Scope_IDENTTY()
	/*select @ID = @@IDENTITY*/

Commit Transaction

 

Select @myTradeID