7) Create a stored procedure, called sp Employees, that returns a select statement that shows all...

Transcribed Image Text:

7) Create a stored procedure, called sp Employees, that returns a select statement that shows all the employees working for the company. This procedure should have the emp full name and employee id columns in your select. 8) Create a stored procedure, called sp. Locations, that returns a select statement that shows all the locations that this bank has. This procedure should have the location id, and location code columns in your select. 7) Create a stored procedure, called sp Employees, that returns a select statement that shows all the employees working for the company. This procedure should have the emp full name and employee id columns in your select. 8) Create a stored procedure, called sp. Locations, that returns a select statement that shows all the locations that this bank has. This procedure should have the location id, and location code columns in your select.