USP_DATAFORMTEMPLATE_ADD_EVENTREGISTRATIONOPPORTUNITYLINK_PRELOAD
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REGISTRANTID | uniqueidentifier | IN | |
| @CONSTITUENTID | uniqueidentifier | INOUT | |
| @REGISTRANTNAME | nvarchar(100) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EVENTREGISTRATIONOPPORTUNITYLINK_PRELOAD
(
@REGISTRANTID uniqueidentifier,
@CONSTITUENTID uniqueidentifier = null output,
@REGISTRANTNAME nvarchar(100) = null output
)
as
set nocount on;
select
@CONSTITUENTID = REGISTRANT.CONSTITUENTID,
@REGISTRANTNAME = NF.NAME
from dbo.REGISTRANT
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REGISTRANT.CONSTITUENTID) NF
where ID = @REGISTRANTID;
return 0;