Guest User

Untitled

a guest
Oct 18th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. 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)
  2.  
  3. CREATE TABLE [dbo].[TestTableDate](
  4. [id] [int] IDENTITY(1,1) NOT NULL,
  5. [date] AS (CONVERT([nvarchar],getdate(),(112))),
  6. [num] [int] NULL
  7. )
Add Comment
Please, Sign In to add comment