SQL Database Usage Considerations

1, in the operation of the database table, be sure to pay attention to the current operation of which database, otherwise it is easy to cause unnecessary errors. For data files in the master database, try not to manipulate them.

2. The database can be backed up by graphical means, and the database can be restored by attaching and restoring the database.

3, in the sorting, for the sorting of multiple fields, the middle is separated by commas;

4, in query statements, for multiple fields of the query, the field does not need to be enclosed in parentheses, and in the UPDATE statement, for the fields that need to add data need to be enclosed in parentheses, and the inserted value needs to be enclosed in parentheses.

SQL Database Usage Considerations