fnDocUploadPartSecurity
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DocID | int | IN |
Definition
Copy
CREATE Function [dbo].[fnDocUploadPartSecurity](@DocID int)
returns table as return
select Part.RequiresApproval [PartApproval],
Part.Guid [PartGuid],
Content.Guid [ContentGuid],
Content.Deleted [ContentDeleted]
from DocUploadFiles Doc inner join DocUploadPart Part on Doc.CID=Part.ID inner join SiteContent Content on Part.SiteContentID=Content.id
where Doc.ID = @DocID