sql server 精简版功能 [英] sql server compact edition features

问题描述

有人知道在哪里可以找到 SQL Server Compact Edition 支持的功能列表吗?我有兴趣在我的网络应用程序中使用新版本，但我正在尝试确定它是否可以满足我的需求?具体我想知道它是否可以支持视图和存储过程，但微软网站是徒劳的.

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.

提前致谢

我看了这个 SQL Server Compact Edition 3.5但这对我没有帮助.

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

推荐答案

SQL Server CE 4 不支持存储过程，您可以在 Scott Guthrie 的这篇博文:

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

SQL CE 是一个嵌入式数据库——它使其成为开发和的理想选择轻度使用场景.为了高容量站点和应用程序您可能希望将其迁移到使用 SQL Server Express(这是免费)、SQL Server 或 SQL Azure.这些服务器启用更好可扩展性，更多开发功能(包括像 Stored程序 - 不受支持与 SQL CE)，以及更高级的数据管理能力.

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.

此页面CE 和 SQL Server 之间差异的完整列表.它说 CE 不支持存储过程和视图.

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.

这篇关于sql server 精简版功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！