UFN_GETEDUCATIONALINVOLVEMENTNAME
Returns information about an educational involvement name.
Return
Return Type |
---|
table |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@EDUCATIONALINVOLVEMENTTYPECODEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_GETEDUCATIONALINVOLVEMENTNAME
(
@EDUCATIONALINVOLVEMENTTYPECODEID uniqueidentifier
)
returns table
as
return
(
select
ID,
NAME,
INACTIVE
from
dbo.EDUCATIONALINVOLVEMENTNAME
where
EDUCATIONALINVOLVEMENTTYPECODEID = @EDUCATIONALINVOLVEMENTTYPECODEID
)