Function:
[AdventureWorks2016CTP3].[dbo].[ufnGetAccountingEndDate]
Name | Value |
Schema | [dbo] |
Owner | [dbo] |
Creation date | 16.11.2015 |
Type | Scalar |
Is schema bound | |
Is deterministic | |
Encrypted | |
Implementation type | Transact SQL |
ID | 1357247890 |
Name | Value |
QUOTED_IDENTIFIER | ON |
ANSI_NULLS | ON |
Name | Datatype | Max length |
@Return | datetime | 8 |
Object name | Object type | Dep level |
[Sales].[uSalesOrderHeader] | Trigger | 1 |
Name | Value |
MS_Description | Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]() RETURNS [datetime] AS BEGIN RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112)); END; GO EXEC sp_addextendedproperty N'MS_Description', N'Scalar function used in the uSalesOrderHeader trigger to set the starting account date.', 'SCHEMA', N'dbo', 'FUNCTION', N'ufnGetAccountingEndDate', NULL, NULL GO |