Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE AccountHierarchy_LDR(idExtration int NOT NULL IDENTITY((YEAR(GETDATE()) * 10000 + MONTH(GETDATE()) * 100 + DAY(GETDATE())), 0), idAccountHierarchy varchar(255) NOT NULL, ItemName varchar(255), HierarchyLevel int)
- CREATE TABLE [dbo].[TestTableDate](
- [id] [int] IDENTITY(1,1) NOT NULL,
- [date] AS (CONVERT([nvarchar],getdate(),(112))),
- [num] [int] NULL
- )
Add Comment
Please, Sign In to add comment