DP44/DataPRO_sql/dbo.sp_DASChannelsInsert.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_DASChannelsInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_DASChannelsInsert]
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_DASChannelsInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_DASChannelsInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_DASChannelsInsert] 
			@HardwareId						nvarchar(50)
           ,@ChannelIdx						int
           ,@SupportedBridges				int
           ,@SupportedExcitations			int
           ,@DASDisplayOrder				int
           ,@LocalOnly						bit
           ,@SupportedDigitalInputModes		int
           ,@SupportedSquibFireModes		int
           ,@SupportedDigitalOutputModes	int
           ,@ModuleSerialNumber				nvarchar(16)
           ,@ModuleArrayIndex				int
		   ,@new_id							int				OUTPUT
		   ,@errorNumber					int				output
		   ,@errorMessage					nvarchar(250)	output 
AS
BEGIN
	SET NOCOUNT ON;
	set @errorNumber = 0 
	set @errorMessage = space(0)

	INSERT INTO [dbo].[DASChannels]
           ([DASId]
           ,[ChannelIdx]
           ,[SupportedBridges]
           ,[SupportedExcitations]
           ,[DASDisplayOrder]
           ,[LocalOnly]
           ,[SupportedDigitalInputModes]
           ,[SupportedSquibFireModes]
           ,[SupportedDigitalOutputModes]
           ,[ModuleSerialNumber]
           ,[ModuleArrayIndex])
     VALUES
           (dbo.foo_IdGetDAS(@HardwareId)
           ,@ChannelIdx
           ,@SupportedBridges
           ,@SupportedExcitations
           ,@DASDisplayOrder
           ,@LocalOnly
           ,@SupportedDigitalInputModes
           ,@SupportedSquibFireModes
           ,@SupportedDigitalOutputModes
           ,@ModuleSerialNumber
           ,@ModuleArrayIndex)

	set @new_id = SCOPE_IDENTITY();
END






























GO