Stored Procedure Icon dbo.forums_UpdateMessageTemplateList

Stored Procedure Properties

Name Value
Owner dbo
Created 2004-05-31
Startup False
Encrypted False

Creation Options

Name Value
QUOTED_IDENTIFIER OFF
ANSI_NULLS OFF

Parameters

Name DataType Length Type
@MessageID int 4 INPUT
@Title nvarchar 512 INPUT
@Body nvarchar 8000 INPUT

Total: 3 parameter(s)

SQL

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO




create procedure forums_UpdateMessageTemplateList
(
	@MessageID int,
	@Title NVarChar(256),
	@Body NVarChar(4000)
)
 AS
UPDATE
	Messages
SET
	Title = @Title,
	Body = @Body
WHERE
	MessageID = @MessageID
	







GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


					

Generated on 26/08/2004 15:05:33 by DataAide.