Last updated on August 3, 2020
Database diagram used for some learning (Bikestore)
The rest is here:
In MSSM, on every object there it a property options, if you do some changes, you can press the script before the change is applied to get the SQL used.
Run just portions of the query, mark the section and execute:
docs microsoft sql server
INNER JOIN (Get all that matches on both tables)
SELF JOIN, related to get the manger
Right-click on the specific table name and choose Design option
Right-click on the window->properties
And we are there (after the change, save solution and disconnect-connect.
View all functions made or present in database:
Then I am done (summer 2020):