IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_MMEFiguresUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_MMEFiguresUpdate]
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_MMEFiguresUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_MMEFiguresUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_MMEFiguresUpdate]
			 @ID				int
			,@txtShortName		nvarchar(100)
			,@txtDescription	nvarchar(255)
			,@txtRemarks		nvarchar(255)
			,@datRevision		datetime
			,@intAuthor			int
			,@intPage			smallint
			,@intPages			smallint
			,@txtImageFile		nvarchar(50)
			,@intVersion		int
			,@bolExpired		bit
			,@txtSortkey		nvarchar(50)
			,@bitStdPath		bit
			,@IntIDStdPath		int
			,@txtPath			nvarchar(255)
			,@LAST_CHANGE		datetime
			,@LAST_CHANGE_TEXT	nvarchar(255)
			,@HISTORY			nvarchar(max)
			,@errorNumber		int				output
			,@errorMessage		nvarchar(250)	output 

AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)

	SET NOCOUNT ON;
	UPDATE [dbo].[MMEFigures]
	   SET [txtShortName]			= @txtShortName		
		  ,[txtDescription]			= @txtDescription		
		  ,[txtRemarks]				= @txtRemarks			
		  ,[datRevision]			= @datRevision		
		  ,[intAuthor]				= @intAuthor			
		  ,[intPage]				= @intPage			
		  ,[intPages]				= @intPages			
		  ,[txtImageFile]			= @txtImageFile		
		  ,[intVersion]				= @intVersion			
		  ,[bolExpired]				= @bolExpired			
		  ,[txtSortkey]				= @txtSortkey			
		  ,[bitStdPath]				= @bitStdPath			
		  ,[IntIDStdPath]			= @IntIDStdPath		
		  ,[txtPath]				= @txtPath			
		  ,[LAST_CHANGE]			= @LAST_CHANGE		
		  ,[LAST_CHANGE_TEXT]		= @LAST_CHANGE_TEXT	
		  ,[HISTORY]				= @HISTORY
	 WHERE [ID]						= @ID					
      


END




























GO