Last updated on August 3, 2020
Database diagram used for some learning (Bikestore)
The rest is here:
https://github.com/spawnmarvel/t-sql
https://github.com/spawnmarvel/t-sql
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
https://docs.microsoft.com/nb-no/sql/?view=sql-server-ver15
CASE expression
https://github.com/spawnmarvel/t-sql/blob/master/module3.sql
Joins
https://github.com/spawnmarvel/t-sql/blob/master/module4_multiple_tables.sql
INNER JOIN (Get all that matches on both tables)
SELF JOIN, related to get the manger
Change schema:
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.
Connected again:
View all functions made or present in database:
Then I am done (summer 2020):
