All 7 T-SQL Fundamentals & Syntax questions
More in T-SQL Fundamentals & Syntax
How do you declare and use a variable in T-SQL? How do IF and WHILE control flow statements work in T-SQL, and what kinds of tasks are they typically used for? What is the difference between a batch and a transaction in T-SQL, and how does the GO keyword relate to batches? What are the differences between the various string functions available in T-SQL, such as SUBSTRING, CONCAT, and TRIM? How do CASE expressions work in T-SQL, and how can they be used to implement conditional logic directly within a SELECT statement? How would you write a T-SQL script that combines variables, control flow, and error handling together to perform a robust, multi step administrative task?
Advertisement
Back to results for “Fundamentals”
SQL Server › T-SQL Fundamentals & Syntax

What is T-SQL, and how does it relate to standard SQL?

Beginner

Answer

T-SQL, short for Transact-SQL, is Microsoft's extension of standard SQL used specifically in SQL Server, adding extra features beyond the standard SQL language, such as procedural programming constructs like variables, loops, and error handling, that let you write more powerful logic directly within the database.
DECLARE @Count INT;
SET @Count = 10;
IF @Count > 5
  PRINT 'Count is greater than five';
Real-world example A developer familiar with standard SQL learns T-SQL's additional procedural features, like variables and IF statements, to build more sophisticated logic directly within SQL Server stored procedures.

Common follow-ups: What specific features does T-SQL add beyond standard ANSI SQL?;Are T-SQL scripts portable to other database systems like MySQL or PostgreSQL?

Stored Procedures & Functions;Error Handling with TRY CATCH
All 7 T-SQL Fundamentals & Syntax questions