开发者

sql server compact edition features

Does anyone know where I can find a list of supported features for SQL Server Compact Edition? I am interested in using the new version with my web app but am trying to determine if it can do what I need? specifically I want to know if it can support views and stored 开发者_运维问答procedures but the microsoft site was futile.

thanks in advance

Edit:

I looked at this SQL Server Compact Edition 3.5 but it was not helpful to me.


SQL Server CE 4 does not support stored procedures, as you can read in this blog post by Scott Guthrie:

SQL CE is an embedded database – which makes it ideal for development and light-usage scenarios. For high-volume sites and applications you’ll probably want to migrate it to use SQL Server Express (which is free), SQL Server or SQL Azure. These servers enable much better scalability, more development features (including features like Stored Procedures – which aren’t supported with SQL CE), as well as more advanced data management capabilities.

This page has a complete list of the difference between CE and SQL Server. It says that both stored procedures and views are not supported by CE.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜