Difference between SQL (ansi) and Transact SQL 2

[Louise99]

Any concise explanations or is it someone I need to research?




Thanks!

 

[AlexCuse]

I think you will need to research it. The ANSI standard is a rather large document.

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[LNBruno]

There shouldn't be any. T-SQL should be written using the ANSI standard.

Case in point: joining tables. You can join using the deprecated method:

FROM table1, table2
WHERE table1.id = intVal1
   AND table2.id = intVal1

but the "more better" method is using the ANSI standard:

FROM table1
JOIN table2
   ON table2.id = table1.id
WHERE table1.id = intVal1

< M!ke >
Acupuncture Development: a jab well done.

 

[r937]

There shouldn't be any.

that would be funny if it weren't so sad, because there are plenty of differences


for example,

http://www.karaszi.com/SQLServer/download/ANSI vs SQL Server Functions.xls

:-(

r937.com | rudy.ca

 

[LNBruno]

Too true, Rudy, and the reason why "should" was in bold! But we can try, can't we? ;-)

Lord, you give them eyes, but they cannot see!

< M!ke >
Acupuncture Development: a jab well done.

 

[AlexCuse]

Thanks for passing along that spreadsheet Rudy. I have never seen all the differences listed in one place before.

It looks like my suspicions are correct, I am pretty good except for the date/time and string manipulation functions (but who needs to use those, right :-( )

Anyways, have a * for sharing :-D

Ignorance of certain subjects is a great part of wisdom

 

[r937]

thanks

there's also a spreadsheet for the difference in datatypes

http://www.karaszi.com/SQLServer/download/ANSI vs SQL Server Datatypes.xls

r937.com | rudy.ca