TheBulgarianWolf

Create, Modify and Print SQL Table

Nov 24th, 2020
1,190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.51 KB | None | 0 0
  1. CREATE TABLE PERSONS(
  2.     PersonID int,
  3.     FirstName varchar(40),
  4.     LastName varchar(40),
  5.     Address varchar(80),
  6.     City varchar(40)
  7. );
  8.  
  9. INSERT INTO PERSONS(PersonID,FirstName,LastName,Address,City)
  10. VALUES(1,'George','Michael','Brooklyn Road 151','New York');
  11.  
  12. INSERT INTO PERSONS(PersonID,FirstName,LastName,Address,City)
  13. VALUES(2,'Jim','Timberland','Lyule Road 18','Haskovo');
  14.  
  15. INSERT INTO PERSONS(PersonID,FirstName,LastName,Address,City)
  16. VALUES(3,'Anna','Smith','Tsar Petur 64','Moskow');
  17.  
  18. SELECT * FROM PERSONS
  19.  
Add Comment
Please, Sign In to add comment