U9自增长ID

declare @SNIndex bigint
exec [dbo].[AllocSerials]    @AllocCount = 1,    @StartSN = @SNIndex output

insert into fa_AssetDepreciateScheduleAllocDetail
select 
        @SNIndex 
      ,[CreatedOn]
      ,[CreatedBy]
      ,[ModifiedOn]
      ,[ModifiedBy]
      ,[SysVersion]
      ,[ManagementDepartment]
      ,[AssetLocation]
      ,[UsageDepartment]
      ,[UseMan]
      ,[Project]
      ,[Task]
      ,653.88
      ,[AssetDepreciateScheduleDetail]
      ,[UsageOrg]
      ,[AAIStatus]
      ,[IsNeedGenAAI]
      ,[Workcenter] from fa_AssetDepreciateScheduleAllocDetail where id=1002907228567488