USP_SITEIMAGES_GETPROFILEPHOTOINFO
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @USERID | int | IN |
Definition
Copy
CREATE procedure dbo.USP_SITEIMAGES_GETPROFILEPHOTOINFO
(
@USERID int
)
as
begin
select SI.ID, SI.ThumbX, SI.ThumbY, SI.ThumbLength, SI.InTrashBin
from SiteImages SI
where SI.OwnerID = @USERID
and SI.Type = 2
end