From the course: Microsoft SQL Server 2016: Query Data

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

To use standards or not

To use standards or not - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Query Data

Start my 1-month free trial

To use standards or not

- [Instructor] In this lesson, we'll explore the use of ANSI Standards SQL, versus Transact-SQL, and when it is best to use which dialect. Pretty much every major database vendor implements ANSI SQL in some form. Most of the core language elements will be the same across the different vendor's database products. Now Best Practice dictates that writing your SQL statements by using the standards as much as possible, helps to create what is known as Portable Code. And if you stick to the standard, your code should run equally well on a Microsoft platform, an Oracle platform, or any other RDBMS that supports and implements ANSI SQL Standard. Now you can deviate from the standard, if your SQL code requires some functionality that's not available in the standard, or perhaps you have an implementation that more closely meets your needs within that vendor-specific SQL language. One common example that is often asked about on forms, such as stack overflow and other SQL online forms, is found…

Contents