USP_SOCIALMEDIASERVICE_GETINFO
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SERVICENAME | nvarchar(100) | IN | |
| @ID | uniqueidentifier | INOUT | |
| @ISACTIVE | bit | INOUT | |
| @ACCEPTSUSERNAME | bit | INOUT | |
| @URLPATTERN | nvarchar(max) | INOUT |
Definition
Copy
create procedure dbo.USP_SOCIALMEDIASERVICE_GETINFO
(
@SERVICENAME nvarchar(100),
@ID uniqueidentifier = null output,
@ISACTIVE bit = 0 output,
@ACCEPTSUSERNAME bit = 0 output,
@URLPATTERN nvarchar(max) = null output
)
as
begin
select
@ID = ID,
@ISACTIVE = ISACTIVE,
@ACCEPTSUSERNAME = ACCEPTSUSERNAME,
@URLPATTERN = URLPATTERN
from
dbo.SOCIALMEDIASERVICE
where
@SERVICENAME = NAME
end