DP44/DataPRO_sql/dbo.sp_TestSetupObjectsInsert.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestSetupObjectsInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestSetupObjectsInsert]
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_TestSetupObjectsInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestSetupObjectsInsert] AS' 
END
GO

ALTER PROCEDURE [dbo].[sp_TestSetupObjectsInsert]
				 @TestSetupId				int = 0
				,@TestObjectId				int = 0
				,@TestObjectName			nvarchar(255) = null
				,@TestSetupName				nvarchar(255) = null
				,@TargetSampleRate			float
				,@ExcitationWarmupTimeMS	int
				,@LocalOnly					bit
				,@TestObjectType			nvarchar(50)
				,@TestObjectPosition		nvarchar(50)
				,@new_id					int				output
				,@errorNumber				int				output
				,@errorMessage				nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0; 	set @errorMessage = space(0); set @new_id = 0;

	begin try
		if(@TestObjectName is null)
		begin 
			set @errorMessage	= 'An invalid parameter or option was specified for procedure'
			set @errorNumber	= 15600
		end	
		else
		begin
			if (@TestSetupId =0)
			begin
				set @TestSetupId = dbo.foo_IdGetTestSetup(@TestSetupName)
			end
		
			if(@TestObjectId =0)
			begin
				set @TestObjectId = dbo.foo_IdGetTestObject(@TestObjectName)
			end
			INSERT INTO [dbo].[TestSetupObjects]
				   ([TestSetupId]
				   ,[TestObjectId]
				   ,[TargetSampleRate]
				   ,[ExcitationWarmupTimeMS]
				   ,[LocalOnly]
				   ,[TestObjectType]
				   ,[TestObjectPosition])
			 VALUES
				   (@TestSetupId
				   ,@TestObjectId
				   ,@TargetSampleRate
				   ,@ExcitationWarmupTimeMS
				   ,@LocalOnly
				   ,@TestObjectType
				   ,@TestObjectPosition)
		
			set @new_id = scope_identity();
		end
		end try
		begin catch
			set @errorMessage	= error_message()
			set @errorNumber	= error_number()
		end catch;
END	






























GO