CREATE PROC spA9T2
AS
BEGIN
  UPDATE tblEmployeeA9
  SET Phone = '(512) 555-0000' WHERE EID = 'SA51'
  SET Street = '1234 Maple' WHERE EID = 'SA51'
  SET City = 'Austin' WHERE EID = 'SA51'
  SET State = 'Tx' WHERE EID = 'SA51'
  SET Zip = '78703' WHERE EID = 'SA51'
  SET Apt = NULL WHERE EID = 'SA51'
END