For help-CodePudding

O can choose delete the update SQL statements from the two table

CodePudding user response:

Can you explain it there? Understanding is poor

CodePudding user response:

reference 1st floor Dear200892 response:

can the pausing for a moment? Poor understanding of

Can ask about from the two tables, delete, update, select, SQL statements?

CodePudding user response:

Each table corresponding to delete, change, check the SQL statement

CodePudding user response:

You learn about ado.net

CodePudding user response:

Join the keyword in the select statement in SQL, update, delete not join, only through the function of the database itself maintain data integrity statement completion,

CodePudding user response:

Change to change room table, and then type table

CodePudding user response:

There should not be modified room and room type of demand at the same time, or it merged into a table, why table? You change the room type at the same time, in a room to edit again is likely to change my room type before,

CodePudding user response:

No matter you are to change the room type or table, you are alone to update a list of information, if you are to be deleted type table, then you need to this type of belong to [into] a temporary room type, delete again

CodePudding user response:

You can write a stored procedure