USP_FAFFRIENDLYURLPARAMS_GET
Get FAF friendly url parameters by sequence ID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEQUENCEID | int | IN | |
| @PAGETYPE | int | INOUT | |
| @PARTICIPANTID | uniqueidentifier | INOUT |
Definition
Copy
create procedure dbo.USP_FAFFRIENDLYURLPARAMS_GET
(
@SEQUENCEID int,
@PAGETYPE int = null output,
@PARTICIPANTID uniqueidentifier = null output
)
as
set nocount on;
select @PAGETYPE = PAGETYPE,
@PARTICIPANTID = PARTICIPANTID
from dbo.FAFFRIENDLYURLPARAMS
where SEQUENCEID = @SEQUENCEID
return 0;