Chapter 3. T-SQL crash course
SQL Server operates using a language called Transact-SQL (T-SQL). It’s a Microsoft-specific variation of the industry-standard Structured Query Language, or SQL. T-SQL is compliant with the industry-standard SQL elements, and adds its own features for things like server management and schema definition. While much of SQL Server can be operated using the GUI, SQL Server’s real power lies in T-SQL (some of the GUI runs T-SQL under the hood). In this chapter, we’ll explore some of the basic data manipulation language (DML) queries in T-SQL.
It’s difficult to understand a lot of how SQL Server works, and even difficult to really work with SQL Server, without knowing a little bit about T-SQL. However, I don’t have a ...
Get Learn SQL Server Administration in a Month of Lunches now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
