Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PL
Starting Member
4 Posts |
 Posted - 2007-12-11 : 03:42:27
|
| Hello,there are some limitations in SQL Server 2005 Mobile Edition - e.g. there is no TRUNCATE TABLE statement, the UPDATE .. FROM clause is not allowed etc. Are these limitations in Compact Edition too? Is T-SQL in these editions functionally equal or different? Is there any comparison of T-SQL features in both editions? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
PL
Starting Member
4 Posts |
Posted - 2007-12-11 : 04:25:24
|
| http://www.microsoft.com/sql/editions/sqlmobile/sqlmobile.mspx |
 |
|
|
PL
Starting Member
4 Posts |
Posted - 2007-12-11 : 06:34:21
|
| Neither of these links refers to T-SQL restrictions nor makes comparison. |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-11 : 06:39:41
|
well in books online I Filter by "SQL Server Mobile" then when I see "Update" in available topics it says "UPDATE statement [SQL Server Compact Edition]" so that makes me think they are the same.Duane.  |
|
|
|
PL
Starting Member
4 Posts |
Posted - 2007-12-11 : 06:45:31
|
| I have downloaded SQL Server 2005 Compact Edition Books Online, which contains information I need. This edition has the same limitations I have mentioned above. So the question is answered. |
|
|
|
|
|
|
Mobile Edition vs. Compact Edition