MySQL using Transact-SQL? I didn't know that. Transact-SQL is an SQL dialect that origins from Sybase, and also used my Microsoft SQL Server, since SQL Server originates from Sybase. MySQL has a completely different background, and I would expect that there are plenty of differences between the two.
For instance, I believe semicolons to terminate statements is mandatory in MySQL, but this is not the case in MySQL. MySQL seems favour backticks to quote identifiers whereas SQL Server prefers brackets. And so on.