TSQL : Unix timestamp into Local time in sql server
DECLARE @epoch bigint
SET@epoch = 1399518300002
select DATEADD(minute, DATEDIFF(minute, getutcdate(), getdate()), DATEADD(s, @epoch/1000, '19700101 00:00:00:000'))
SQL Server MDS : How to Know Actual MDS Table name for Model Entity and Column name for the Attribute
How to Know Actual MDS Table name for Model Entity and Column name for the Attribute . here is the Script USE MDS ------------------------------------------------------------ -- TODO: Define Model name, Entity name, and Attribute Name DECLARE @Model NVARCHAR ( 50 ) = '<<GiveModelName>>' ; DECLARE @Entity_Name NVARCHAR ( 50 ) = '<<GiveEntityName>>' ; DECLARE @Attribute_Name NVARCHAR ( 50 )= '<<GiveAttributeName>>' ; ------------------------------------------------------------ -- Set @Table name DECLARE @Table NVARCHAR ( 128 ); SELECT @Table = EntityTable FROM mdm . viw_SYSTEM_SCHEMA_ENTITY WHERE Model_Name = @Model AND name = @Entity_Name ; --...
Comments
Post a Comment