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