Create a table variable using data in the dbo.HospitalStaff table with the following 4 columns a. Name – Located in the NameJob Column : Everything before the _ b. Job – Located in the NameJob Column : Everything after the _ c. HireDate d. City – Located in the Location Column: Everything before the –
