Create stored procedures PD1_T2, implementation: if any teachers number is "0105" the record, the teacher taught the basic information and delete this message, if there is no this teacher, shows "no the teacher!" , at the same time, according to the lecturer and the information in the table, execute the stored procedure,

CodePudding user response:

Title: help create INSTEADOF trigger
Content: create stored procedure... To perform this ,

CodePudding user response:

Wrong is wrong, to write the wrong question, it should be this
Create tri_sale INSTEADOF triggers, when sales of single input or update the records in the table to determine whether a customer number legal, customer number does not exist, the prompt 'customer number does not exist! Against the integrity of the data. '(submit SQL statements)
(15.0)

CodePudding user response:

Must provide relevant table structure of each table, the test data, the processing logic, and hope the result.