spAdd_ECard

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ClientSitesID	int	IN
@ViewKey	uniqueidentifier	IN
@EmailSubject	nvarchar(4000)	IN
@Html	ntext	IN

Definition

Copy



                CREATE procedure dbo.spAdd_ECard (
                    @PKID int output,
                    @ClientSitesID int,
                    @ViewKey uniqueidentifier,
                    @EmailSubject nvarchar(4000),
                    @Html ntext
                ) as
                    set nocount on;
                    insert into dbo.ECard
                    (
                        ClientSitesID,
                        ViewKey,
                        EmailSubject,
                        Html
                    )
                    values
                    (
                        @ClientSitesID,
                        @ViewKey,
                        @EmailSubject,
                        @Html
                    );
                    set @PKID = @@Identity;