Microsoft SQL Server help needed desperately, need help writing queries that inv
ID: 3731665 • Letter: M
Question
Microsoft SQL Server help needed desperately, need help writing queries that involve the below tables and requirements:
tblAddress AddressID tblCompany CompanylD CompanyName BillingAddressID IsCustomer CustomerVenderSince DateLastModified tblProduct 9 ProductiD City StateProvince PostalCode Country ProductName CurrentStandardUnitPrice tblOrderLine tblCustomerOrder tblEmployee OrderNo EmployeelD LastName FirstName UserName UserPassword Phone SupervisorlD JobPositionlD OrderNo ProductID QuantityOrdered UnitPriceCharged DiscountRate QuantityPicked OrderDate FilledYesNo CompanylD ShippingAddressID EmployeelDTookOrder EmployeelDFilledOrder - tblJobPosition JobPositionID JobTitleExplanation / Answer
Answer i:
Please change the YourLastName, YourFirstName, userName, password and 2395550000 to your actual values in VALUES()
INSERT INTO tblEmployee (LastName, FirstName, UserName, UserPassword, Phone, SupervisorID, JobPositionID)
VALUES ('YourLastName','YourFirstName','userName','password','2395550000','102','7');
COMMIT;
j-1: UPDATE tblEmployee SET UserPassword = 'newPassword', Phone = 'newPhoneNumber' where EmployeeID = '101';
j-2 : DELETE FROM tblEmployee WHERE EmployeeID = '18';