From the course: Querying Microsoft SQL Server 2019

Unlock the full course today

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

What is Transact SQL?

What is Transact SQL? - SQL Server Tutorial

From the course: Querying Microsoft SQL Server 2019

Start my 1-month free trial

What is Transact SQL?

- [Instructor] In the world of relational databases, you won't get very far before you run into a need to be able to read and write commands in SQL. SQL, sometimes pronounced as sequel, stands for structured query language. It's been around for several decades, and it's become the de-facto language for interacting with all relational database management systems. But not all versions of the SQL language are exactly the same. As different companies try to differentiate their database product from those of their competitors, each company introduced unique features and capabilities to the RDBMS that they brought to the market. These unique and differentiating features required small modifications to the language. A specialized function here, a new command there, and eventually the common SQL syntax diverged into different implementations. You can think of SQL dialects like the difference between British English and American…

Contents