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? - SQL Server Tutorial
From the course: Querying Microsoft SQL Server 2019
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…