T-SQL

Transactional S Query Language is used for querying relational databases. Used a lot on MS Sql and Mysql as well as Postgress SQL.

There are however nuances based on the differing technologies being used, for example in the way that pagination is done in MS Sql and Mysql

There are many more but the overall general terms, like SELECT and JOIN are pretty much the same.

Notes

• SQL Noir - SQL Learning Game
• LearnSQL
• Set the max output length for Results to Text in MS SQL Studio 2019
• Sql server management studio dark mode

Query Patterns and Administration

• Add conditional check to a Stored Proc Query
• Add multiple columns to table in MS Sql
• Combine multiple SQL Files into One
• Create stored procedure in MS Sql
• Determine date difference in MS Sql
• Enable Mixed Mode Authentication - Ms SQL
• Find the data for a Foreign key in MSSQL
• Finding Duplicates with SQL
• Get Birthdays for the month (Mysql)
• List users and their database roles in Azure SQL
• Use values as a derived table in SQL

---

📇 Additional Metadata

• 🗂 Type:: note
• 🏷️ Tags::
• 📡 Status:: #status/🌲