|
|
Posted by Erland Sommarskog on 03/09/07 23:12
Plamen Ratchev (Plamen@SQLStudio.com) writes:
> I had to work with the Compact Edition recently and it supports really a
> limited set of T-SQL. There are no stored procedures, user functions,
> control of flow constructs (like IF..ELSE, but CASE is available), views,
> triggers, and cursors. None of the new ranking functions for SQL 2005 are
> available as well as the XML specific handling (like FOR XML). Also, CROSS
> APPLY is not supported, and no DECLARE for variables...
But, it has at least one thing big brother does not have: ALTER TABLE
syntax to add/remove the IDENTITY property. I find it amazing.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|