Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.33 KB | None | 0 0
  1. USE AdventureWorks2012;
  2. GO
  3.  
  4. SELECT
  5.     BusinessEntityID,
  6.     PersonType,
  7.     NameStyle,
  8.     Title,
  9.     FirstName,
  10.     MiddleName,
  11.     LastName,
  12.     Suffix,
  13.     EmailPromotion,
  14.     ModifiedDate
  15. INTO dbo.Person
  16. FROM Person.Person WHERE 1 = 0;
  17. GO
  18.  
  19. ALTER TABLE dbo.Person
  20.     ADD CONSTRAINT BigInt PRIMARY KEY CLUSTERED (ID)
  21.     WITH (FILLFACTOR = 10);
  22. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement