spGetUserAlbums
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @UserID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetUserAlbums]
(
@UserID int
)
AS
SELECT [ID] FROM ImageAlbum WHERE OwnerUserID = @UserID AND AlbumType = 1 AND Deleted = 0 ORDER BY DisplayName ASC