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