DP44/DataPRO_sql/dbo.sp_MMEPhysicalDimensionsUpdate.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_MMEPhysicalDimensionsUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_MMEPhysicalDimensionsUpdate]
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_MMEPhysicalDimensionsUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_MMEPhysicalDimensionsUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_MMEPhysicalDimensionsUpdate]
            @s_GUID						uniqueidentifier = null
           ,@PHYSICAL_DIMENSION			nvarchar(50)
           ,@TEXT_L1					nvarchar(50)
           ,@TEXT_L2					nvarchar(50)
           ,@DEFAULT_UNIT				nvarchar(50)
           ,@LENGTH_EXP					int
           ,@TIME_EXP					int
           ,@MASS_EXP					int
           ,@ELECTRIC_CURRENT_EXP		int
           ,@TEMPERATURE_EXP			int
           ,@LUMINOUS_INTENSITY_EXP		int
           ,@AMOUNT_OFSUBSTANCE_EXP		int
           ,@VERSION					int
           ,@DATE						datetime
           ,@REMARKS					nvarchar(50)
           ,@EXPIRED					bit
           ,@SORTKEY					nvarchar(50)
           ,@LAST_CHANGE				datetime
           ,@LAST_CHANGE_TEXT			nvarchar(50)
           ,@HISTORY					nvarchar(50)
		   ,@errorNumber				int				output
		   ,@errorMessage				nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)
	UPDATE [dbo].[MMEPhysicalDimensions]
	   SET [PHYSICAL_DIMENSION]			= @PHYSICAL_DIMENSION		
		  ,[TEXT_L1]					= @TEXT_L1				
		  ,[TEXT_L2]					= @TEXT_L2				
		  ,[DEFAULT_UNIT]				= @DEFAULT_UNIT			
		  ,[LENGTH_EXP]					= @LENGTH_EXP				
		  ,[TIME_EXP]					= @TIME_EXP				
		  ,[MASS_EXP]					= @MASS_EXP				
		  ,[ELECTRIC_CURRENT_EXP]		= @ELECTRIC_CURRENT_EXP	
		  ,[TEMPERATURE_EXP]			= @TEMPERATURE_EXP		
		  ,[LUMINOUS_INTENSITY_EXP]		= @LUMINOUS_INTENSITY_EXP	
		  ,[AMOUNT_OFSUBSTANCE_EXP]		= @AMOUNT_OFSUBSTANCE_EXP	
		  ,[VERSION]					= @VERSION				
		  ,[DATE]						= @DATE					
		  ,[REMARKS]					= @REMARKS				
		  ,[EXPIRED]					= @EXPIRED				
		  ,[SORTKEY]					= @SORTKEY				
		  ,[LAST_CHANGE]				= @LAST_CHANGE			
		  ,[LAST_CHANGE_TEXT]			= @LAST_CHANGE_TEXT		
		  ,[HISTORY]					= @HISTORY				
	 WHERE [s_GUID]						= @s_GUID
END






























GO