Differences between T-SQL between SQL Server Compact Edition and real SQL Server?

Question

Based on the vast background of SQL Server T-SQL, I had trouble finding any specific documentation describing the differences in T-SQL support between SQL CE and full-blown SQL Server. What are some of the differences you have come across? Is there a T-SQL comparison somewhere side by side? I saw the MSDN documentation here , but I cannot find any details about which T-SQL statements are not portable between the two. One difference that I found right away is the lack of the ISNUMERIC () function. Any others?

NOTE. I'm more interested in differences in DML functionality than DDL and administrative functions, which I am sure are numerous and completely uninteresting.

Answer 1

Here you go, some things here http://msdn.microsoft.com/en-us/library/bb896140(SQL.100).aspx