fnGetEmailSubject
Return
| Return Type |
|---|
| nvarchar(255) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @emailID | int | IN |
Definition
Copy
CREATE FUNCTION dbo.fnGetEmailSubject (@emailID int)
RETURNS nvarchar(255) AS
Begin
declare @sSubject nvarchar(255)
SELECT @sSubject = Subject from dbo.Email where id = @emailID
if @@ROWCOUNT = 0
SELECT @sSubject = ''
RETURN @sSubject
end