In SQL, "add, delete, modify, and query" is the core content. It is precisely because of these that they support the overall operation of the database.
Add: Add new content to the database
Delete: delete database content
Change: modify and update the database
Query: queries the content in the database.
Of course, the method is not a single one. We should choose the most suitable method based on the principle of the maximum principle.
Based on the actual situation, you can get the results you need in the simplest way after you have clearly understood your needs. For example, there are many ways to "add", so how do we add it? We must find out what kind of table and what kind of data; for example, how can we query it, but how can we get the most reliable data in the simplest way? We still need to figure out the most basic functions of each query.
[SQL Server] series, there are other Oh ~
[SQL
Server: "CREATE" of a Transact-SQL statement"
[SQL Server] paradigm