数据访问
SQL CE 限制
l 不支持:
Ø 触发器
Ø 视图
Ø 存储过程
Ø 用户自定义函数
Ø 簇索引(Clustered index)
Ø nText 或 nImage 索引
Ø 计算列

| There are some significant limitations of SQL CE. Remember that SQL CE is designed to be a repository for local application data, not a full database server.
| Tables and indexes are the only major entities you can create. Stored Procedures, Triggers, Views, and User Defined Functions are not supported. For data access, you can use parameterized queries.
| While you can create multi-column indexes, you can not create clustered indexes or indexes on nText or nImage fields.
| Further, computed columns are not supported in your table definitions.