当写一个insert语句时，某一字段需要从需要插入的数据库中获取其最大值并且加1



ALTER  PROCEDURE [dbo].[T_InsertMX]
 -- Add the parameters for the stored procedure here
 (
        @sReport nvarchar(50),
        @fName nvarchar(50),
        @fModel nvarchar(50),
        @fNumber nvarchar(50),
        @fManufacturer nvarchar(50),
        @fValidity nvarchar(50),
        @result nvarchar(50) output
    )
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;
 set @result='失败'
  declare @fOrder nvarchar(50)
  set @fOrder=0
    if  exists(select sReport from Tmp_TestReportMX where sReport=@sReport )
        select @fOrder=max(forder) from Tmp_TestReportMX where sReport=@sReport
    -- Insert statements for procedure here
 Insert Into Tmp_TestReportMX(sReport,fOrder,fName,fModel,fNumber,fManufacturer,fValidity)
 values(@sReport ,@fOrder+1,@fName,@fModel,@fNumber,@fManufacturer,@fValidity)
 
 set @result='成功'
END