Build a stored procedure, requirements to insert a Course information, Course list at insert time to check whether there is in the classroom teachers teaching model, if there is no hint cannot insert record warning information, if there are, it shows that the teachers of the number and of Course, set up and execute the stored procedure,

CodePudding user response:

Establish a stored procedure: changes the value of the customer table integral column makes customer's integral is equal to the purchase of ten percent of the total sales price (only change the purchase record of customer, can use multiple statements), bosses, this how to do