-
Book Overview & Buying
-
Table Of Contents
Apps and Services with .NET 10 - Third Edition
By :
Transact-SQL (T-SQL) is SQL Server’s dialect of Structured Query Language (SQL). Some pronounce it tee-sequel, others tee-es-queue-el.
Unlike C#, T-SQL is not case-sensitive; for example, you can use int or INT to specify the 32-bit integer data type, and you can use SELECT or select to start a query expression. Text data stored in SQL Server tables can be treated as case-sensitive or not, depending on the configuration.
T-SQL is based on the ANSI SQL standard, but it extends it with additional keywords and features specific to SQL Server. These extensions allow you to write procedural logic such as loops and conditionals, manage transactions, handle errors, and work with variables. In other words, T-SQL turns SQL from a purely declarative language (“what data do you want?”) into a language that can also describe how to process that data on the server.
You use T-SQL whenever you communicate with a SQL Server database...