asked
SQL Mobile command xref?
Can someone point me to a decent cross reference of the SQL statements supported/not supported by SQL Mobile? I keep bumping me head against these things and would like to find out once and for all what is and is not supported. TIA! Sean
It looks like the T-SQL of SQL Mobile is well documented in [BOL][1]. This is not a cross reference but still pretty useful. Here is the list of features which I am aware are not supported by T-SQL mobile: - Nested transactions (though not nested transactions are still supported) - Stored procedures - XML data type (and therefore XQuery) - Top N queries The maximum size of the database file is 4 GB. Password for the database file is optional (just like in SQL Server 7 you can have a blank password for sa, you can have totally unprotected SQL mobile databases). Oleg [1]:
http://technet.microsoft.com/en-us/library/ms173372(SQL.100).aspx
I do a lot of mobile development and use SQL CE often, one trick I've used to emulate stored procs is demonstrated here
http://www.sqlshare.com/using-managed-procs-with-sql-compact_483.aspx Get familiar with sqlceresultset and tabledirect commands, they can really boost performance over basic T-SQL
http://msdn.microsoft.com/en-us/library/dd938877.aspx Also, normally in a database application you want to open a connection and then close it as soon as possible, with SQL CE it is often better to leave the connection open for the lifetime of your app
