Use the View manager to write efficient SQLSELECT statements. For beginners, it has always been a bit confusing to write SQL statements without throwing bricks. there is no good error checking mechanism at the time of writing, and errors can only be found at the time of running, especially for beginners, never throw bricks
Writing SQL statements has always been a bit confusing. when writing SQL statements, there is no good error checking mechanism, and errors can only be found at runtime, especially when there are more than one associated table, my thoughts may be confused and I don't know where I am lost. Recently, it was accidentally discovered that M $ did not provide a good silly interface for our lazy students to use, but we turned a blind eye to ourselves, that is, the View Manager in SQL Server, it not only makes it easy for us to query multiple tables without ignoring the relationship between them (of course, there must be a necessary relationship between multiple tables ), you can also use it to set aliases, sorting, conditions, and so on, and then automatically generate good-style SQL SELECT statements, and test the running results. Let's talk about this nonsense. let's take a look at the image below and try it on our own :-)
(
The preparation of SQL statements by Explain has always been a bit confusing. there is no good error checking mechanism in writing, and errors can only be found at runtime, especially Association...
