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?
  • НаукаНаука

Комментарии • 8

  • @drewcipher896
    @drewcipher896 Год назад +12

    2:40 today years old when I learned dragging a table into a query was a thing.

  • @juviscript
    @juviscript 8 месяцев назад +1

    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!

    • @SQLServer101
      @SQLServer101  8 месяцев назад

      Hi Juvi. I'm glad that helped. Phillip

  • @robbinsethi7476
    @robbinsethi7476 2 года назад +1

    Great video with clear explanation!

  • @kebincui
    @kebincui Год назад +1

    great video, thanks for sharing

  • @lesingaming5371
    @lesingaming5371 2 года назад

    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 ?

  • @annamontage
    @annamontage 2 года назад +1

    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 :)

    • @SQLServer101
      @SQLServer101  2 года назад

      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