Practice #3

• Edit existing table

ALTER TABLE dboCustomer 
    ADD AccountManager int NULL 
    REFERENCE dboAccountManagers(EmployeeID);

• Update the Multiple Table Values

UPDATE dboCustomer SET AccountManager = 1;

• Try to add some rows into table

INSERT INTO dboCustomer VALUES ("Rhonda", NULL, "Hughes", DEFAULT, 1000, 2);

INSERT INTO dboCustomer VALUES ("Arnold", NULL, "Swaseneger", DEFAULT, 800, 9);