Function:
[AdventureWorks2016CTP3].[dbo].[ufnGetAccountingStartDate]
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 | 1341247833 |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
Recordset returned
| Name | Datatype | Max length |
| @Return | datetime | 8 |
Objects that depend on [dbo].[ufnGetAccountingStartDate]
| Object name | Object type | Dep level |
| [Sales].[uSalesOrderHeader] | Trigger | 1 |
Extended properties
| Name | Value |
| MS_Description | Scalar function used in the uSalesOrderHeader trigger to set the ending account date. |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]() RETURNS [datetime] AS BEGIN RETURN CONVERT(datetime, '20030701', 112); END; GO EXEC sp_addextendedproperty N'MS_Description', N'Scalar function used in the uSalesOrderHeader trigger to set the ending account date.', 'SCHEMA', N'dbo', 'FUNCTION', N'ufnGetAccountingStartDate', NULL, NULL GO |
See also