What is the difference between "standard" SQL and Microsoft's T-SQL query language?
HTML-код
- Опубликовано: 20 апр 2021
- In this video, we'll look at the differences between the standard ISO/ANSI SQL language and the dialect of SQL used by Microsoft.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpiv...
----
My Excel for PC courses are:
Beginner to Excel - rebrand.ly/microsoft-excel-sp...
Intermediate to Expert Advanced - rebrand.ly/microsoft-excel-ex...
Power Table, Get and Transform and Power Pivot - rebrand.ly/visualizing-data-e...
VBA macros for Excel - rebrand.ly/excel-vba-pc
----
In this video, we'll have a look at:
What are SQL and T-SQL?
Referring to objects with a space in their name
Reducing the numbers of rows returned in a query
Do you need to use the FROM clause?
Procedural programming
Functions
Expanded DDL statements
Data types, and
What conclusions can you reach? - Наука
2:40 today years old when I learned dragging a table into a query was a thing.
So far, I've watched 3 videos about the differenced between SQL and T/SQL, and yours is the ONLY one that has made any sense at all. Thank you!
Hi Juvi. I'm glad that helped. Phillip
Great video with clear explanation!
great video, thanks for sharing
I have 1 question about sql so I'm totally new in this SQL field so if T-SQL is a dialect of Microsoft SQL server so there are any dialect of my SQL ?
Hey there, thank you for your videos :) You definitely should have a Patreon or something similar as you deserve it ;) Don't stop doing what you do :)
Thank you. I do have some Udemy videos if you do want to support me. Have a look at my website, www.filecats.co.uk , for more details. Phillip