IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_SensorCalibrationRecordInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_SensorCalibrationRecordInsert]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_SensorCalibrationRecordInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_SensorCalibrationRecordInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_SensorCalibrationRecordInsert]
			  @SensorId					int
			, @SensorCalibrationId		int 
			, @IsModel					bit 
			, @Sensitivity				float
			, @AtCapacity				bit
			, @EngineeringUnits			nvarchar(20) 
			, @Excitation				nvarchar(10) 
			, @CapacityOutputIsBasedOn	smallint 
			, @SensitivityUnits			nvarchar(10)
			, @ZeroPoint				float
		    , @new_id					int				output
		    ,@errorNumber				int				output
		    ,@errorMessage				nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)
	if(@SensorId is null)
	begin 
		RAISERROR(15600,-1,-1, 'sp_SensorCalibrationRecordInsert') /* Error 1560 - An invalid parameter or option was specified for procedure*/
	end
	else
	begin

		insert into [dbo].[SensorCalibrationRecord]
			    ( SensorId    
				, SensorCalibrationId 
				, IsModel 
				, Sensitivity            
				, AtCapacity 
				, EngineeringUnits     
				, Excitation 
				, CapacityOutputIsBasedOn 
				, SensitivityUnits 
				, ZeroPoint)
		values
				( @SensorId					
				, @SensorCalibrationId		
				, @IsModel					
				, @Sensitivity				
				, @AtCapacity				
				, @EngineeringUnits			
				, @Excitation				
				, @CapacityOutputIsBasedOn	
				, @SensitivityUnits			
				, @ZeroPoint)
		set @new_id = scope_identity()
	end
END































GO