-- Insert a New Employee

/******************************
Both of the inserts below will work in SQL Server

Oracle
******************************/
INSERT INTO Employees
(LastName, FirstName, Title, TitleOfCourtesy,
    BirthDate, HireDate, Address, City, Region,
    PostalCode, Country, HomePhone, Extension)
VALUES ('Dunn', 'Nat', 'Sales Representative', 'Mr.', '19-Feb-1970',
    '15-Jan-2004', '4933 Jamesville Rd.', 'Jamesville', 'NY',
    '13078', 'USA', '315-555-5555', '130');

/******************************
MySQL
******************************/
INSERT INTO Employees
(LastName, FirstName, Title, TitleOfCourtesy,
    BirthDate, HireDate, Address, City, Region,
    PostalCode, Country, HomePhone, Extension)
VALUES ('Dunn', 'Nat', 'Sales Representative', 'Mr.', '1970-02-19',
    '2004-01-15', '4933 Jamesville Rd.', 'Jamesville', 'NY',
    '13078', 'USA', '315-555-5555', '130');