spGetMessages_Custom
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@MessageFolderID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetMessages_Custom]
(
@MessageFolderID int
)
AS
BEGIN
-- Get Sent Messages In Folder
SELECT
1 'MessageType',
o.ID 'MessageID',
o.Viewed
FROM [Message] o
WHERE
o.Deleted = 0
AND o.MessageFolderID = @MessageFolderID
END