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 |
---|---|---|---|
@EmailID | int | 4 | INPUT |
@Subject | nvarchar | 100 | INPUT |
@Message | ntext | 16 | INPUT |
Total: 3 parameter(s)
SQL
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO create procedure forums_UpdateEmailTemplate ( @EmailID int, @Subject nvarchar(50), @Message ntext ) AS -- Update a particular email message UPDATE Emails SET Subject = @Subject, Message = @Message WHERE EmailID = @EmailID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO