Results
Name
Messages
1 City Park
Question 8:
Picture 7.1
[1] Write a query to insert multiple new staff members into the Staffs table with their names and phone numbers as follow:
name = 'John Doe', phone '555-987-6543'
name 'Jane Smith', phone= '555-654-3210'
name = 'Alice Brown', phone = '555-123-7890'
Question 9:
[1] Write a query to update the phone number of staff members based on specific conditions.If the current phone number starts with '555', change it to '999', otherwise leave it unchanged.
Question 10:
[1] Create a stored procedure named proc_Staffs with the following parameters: @StaffIDINT, @NewPhone VARCHAR(15) to update the employee phone number by given parameters
Zoom
+ 100%
Close
