INSERT INTO Employees (FirstName, LastName, DepartmentID, Title, Salary, EmailAddress, PhoneExtension,
HomeAddress)
VALUES ('#form.FirstName#', '#form.LastName#',#form.DepartmentID#, '#form.Title#','#form.Salary#',
'#form.EmailAddress#', '#form.PhoneExtension#','#form.HomeAddress#')
New Employee: #form.Lastname#, #form.FirstName# (Last, First) has been added to the database.
DELETE FROM Employees
WHERE EmployeeID = #form.EmployeeID#;
Employee: #Form.Lastname#, #Form.FirstName# (Last, First) has been deleted from the database.
UPDATE Employees
SET FirstName = '#form.FirstName#',
LastName = '#form.LastName#',
DepartmentID = #form.DepartmentID#,
Title = '#form.Title#',
Salary = '#form.Salary#',
EmailAddress = '#form.EmailAddress#',
PhoneExtension = '#form.PhoneExtension#',
HomeAddress = '#form.HomeAddress#'
WHERE EmployeeID = #form.EmployeeID#;
Employee: #Form.Lastname#, #Form.FirstName# (Last, First) has been updated in the database.
GO BACK to view the results.