DP44/DataPRO_sql/dbo.sp_MMEPossibleChannelsInsert.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_MMEPossibleChannelsInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_MMEPossibleChannelsInsert]
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_MMEPossibleChannelsInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_MMEPossibleChannelsInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_MMEPossibleChannelsInsert]
            @TYPE						nvarchar(50)
           ,@TEST_OBJECT				nvarchar(50)
           ,@POSITION					nvarchar(50)
           ,@TRANS_MAIN_LOC				nvarchar(50)
           ,@FINE_LOC_1					nvarchar(50)
           ,@FINE_LOC_2					nvarchar(50)
           ,@FINE_LOC_3					nvarchar(50)
           ,@PHYSICAL_DIMENSION			nvarchar(50)
           ,@DIRECTION					nvarchar(50)
           ,@DEFAULT_FILTER_CLASS		nvarchar(50)
           ,@TEXT_L1					nvarchar(100)
           ,@TEXT_L2					nvarchar(100)
           ,@VERSION					int
           ,@DATE						datetime
           ,@REMARKS					nvarchar(50)
           ,@EXPIRED					bit
           ,@SORTKEY					nvarchar(50)
           ,@PICTURE_SHORTNAME			nvarchar(50)
           ,@LAST_CHANGE				datetime
           ,@LAST_CHANGE_TEXT			nvarchar(50)
           ,@HISTORY					nvarchar(50)
		   ,@new_id						int OUTPUT
		   ,@errorNumber				int				output
		   ,@errorMessage				nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)
	
INSERT INTO [dbo].[MMEPossibleChannels]
           ([TYPE]
           ,[TEST_OBJECT]
           ,[POSITION]
           ,[TRANS_MAIN_LOC]
           ,[FINE_LOC_1]
           ,[FINE_LOC_2]
           ,[FINE_LOC_3]
           ,[PHYSICAL_DIMENSION]
           ,[DIRECTION]
           ,[DEFAULT_FILTER_CLASS]
           ,[TEXT_L1]
           ,[TEXT_L2]
           ,[VERSION]
           ,[DATE]
           ,[REMARKS]
           ,[EXPIRED]
           ,[SORTKEY]
           ,[PICTURE_SHORTNAME]
           ,[LAST_CHANGE]
           ,[LAST_CHANGE_TEXT]
           ,[HISTORY])
     VALUES
           (@TYPE					
           ,@TEST_OBJECT			
           ,@POSITION				
           ,@TRANS_MAIN_LOC			
           ,@FINE_LOC_1				
           ,@FINE_LOC_2				
           ,@FINE_LOC_3				
           ,@PHYSICAL_DIMENSION		
           ,@DIRECTION				
           ,@DEFAULT_FILTER_CLASS	
           ,@TEXT_L1				
           ,@TEXT_L2				
           ,@VERSION				
           ,@DATE					
           ,@REMARKS				
           ,@EXPIRED				
           ,@SORTKEY				
           ,@PICTURE_SHORTNAME		
           ,@LAST_CHANGE			
           ,@LAST_CHANGE_TEXT		
           ,@HISTORY)		
	
	set @new_id	= scope_identity()

END






























GO