February 22, 2012 at 7:42 am
February 22, 2012 at 8:09 am
Transact-SQL, also known as T-SQL.
February 22, 2012 at 8:58 am
Are declaring variables and if statements considered part of T-SQL? They're more VBA than SQL from an overview
February 22, 2012 at 9:02 am
Anything you write and run in SSMS is T-SQL. You can implement CLR to access .Net and C#, but that reaches out of SQL Server to grab the assemblies and run them. The CLR implementing / calling code is T-SQL.
Yes, MS is using conventions of other languages and bringing them into T-SQL. That does not make it another language, though.
February 22, 2012 at 9:02 am
http://en.wikipedia.org/wiki/Transact-SQL
Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. SQL, often expanded to Structured Query Language, is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements. These additional features make Transact-SQL Turing complete.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply