title: T-SQL differences between SQL Server Compact Edition and real SQL Server?
body: <p>Coming from an extensive SQL Server T-SQL background, I'm having 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've run into?  Is there a side-by-side T-SQL comparison somewhere?  I've seen the MSDN documentation <a href="http://msdn.microsoft.com/en-us/library/bb686876%28v=SQL.100%29.aspx" rel="noreferrer">here</a>, but I cannot seem to find any details about what T-SQL statements aren't portable between the two.  One difference I found right away is the lack of an ISNUMERIC() function.  Any others?</p>
  
  <p>NOTE: I'm specifically more interested in differences in DML functionality than DDL and administrative functions which I'm sure are numerous and completely uninteresting.</p>