CREATE TABLE Employees ( EmpID INT PRIMARY KEY, LastName VARCHAR(50), FirstName VARCHAR(50), Title VARCHAR(50), Address VARCHAR(100), City VARCHAR(50), Country VARCHAR(50), HomePhone VARCHAR(20) ); INSERT INTO Employees (EmpID, LastName, FirstName, Title, Address, City, Country, HomePhone) VALUES (1, 'Davolio', 'Nancy', 'Sales Rep.', '507 - 20th Ave. E. Apt. 2A', 'Seattle', 'USA', '(206) 555-9857'), (2, 'Fuller', 'Andrew', 'Vice President', '908 W. Capital Way', 'Tacoma', 'USA', '(206) 555-9482'), (3, 'Leverling', 'Janet', 'Sales Rep.', '722 Moss Bay Blvd.', 'Kirkland', 'USA', '(206) 555-3412'), (4, 'Peacock', 'Margaret', 'Sales Rep.', '4110 Old Redmond Rd.', 'Redmond', 'USA', '(206) 555-8122'), (5, 'Buchanan', 'Steven...
Komentar
Posting Komentar