Function:
[AdventureWorks2016CTP3].[dbo].[ufnGetDocumentStatusText]
Function properties
| Name | Value |
| Schema | [dbo] |
| Owner | [dbo] |
| Creation date | 16.11.2015 |
| Type | Scalar |
| Is schema bound | |
| Is deterministic | |
| Encrypted | |
| Implementation type | Transact SQL |
| ID | 1453248232 |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
Parameters
| Name | Description | DataType | Max length | ReadOnly |
| @Status | tinyint | 1 |
Recordset returned
| Name | Datatype | Max length |
| @Return | nvarchar | 16 |
Extended properties
| Name | Value |
| MS_Description | Scalar function returning the text representation of the Status column in the Document table. |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[ufnGetDocumentStatusText](@Status [tinyint]) RETURNS [nvarchar](16) AS -- Returns the sales order status text representation for the status value. BEGIN DECLARE @ret [nvarchar](16); SET @ret = CASE @Status WHEN 1 THEN N'Pending approval' WHEN 2 THEN N'Approved' WHEN 3 THEN N'Obsolete' ELSE N'** Invalid **' END; RETURN @ret END; GO EXEC sp_addextendedproperty N'MS_Description', N'Scalar function returning the text representation of the Status column in the Document table.', 'SCHEMA', N'dbo', 'FUNCTION', N'ufnGetDocumentStatusText', NULL, NULL GO EXEC sp_addextendedproperty N'MS_Description', N'Input parameter for the scalar function ufnGetDocumentStatusText. Enter a valid integer.', 'SCHEMA', N'dbo', 'FUNCTION', N'ufnGetDocumentStatusText', 'PARAMETER', N'@Status' GO |
See also