T-SQL

[teng84]

can someone point me a good TSQL tutorial primarily mysql

 

and can somebody tell me importance or the advantages of TSQL

[Barand]

The only T-SQL I'm aware of is MSSQL, not MySQL.

 

Try Google.

[TheFilmGod]

The only T-SQL I'm aware of is MSSQL, not MySQL.

 

Try Google.

 

I never heard of T-sql. Very interested in finding out what it is. Maybe someone can explain...

[teng84]

i tried google but i was thingkinh like im gonna have something differen here

 

and yah , most of TSQl os used in ms mot in my but i have seen some of the codes that i am modefying where it uses tsql?

something like

if, when, then etc.. i have an idea how ot use them but i really want to be good in using them

[Barand]

T-SQL, or Transactional SQL , is the flavour of SQL used by MS SQL Server. As with many things MS, if the rest of the world has a standard for something, MS impose a new one. Some of the biggest differences from MySQL's version of SQL will be found in T-SQL's (paltry) date/time functions.

[fenway]

Some of the biggest differences from MySQL's version of SQL will be found in T-SQL's (paltry) date/time functions.

Yeah, no kidding, I had do some reporting and to get the DATE part of a DATETIME field I had to do this:

 

SUBSTRING( CONVERT(varchar, l.triggered_on, 20 ), 1, 10 )