如何在SqlCE中使用存储过程 [英] How to use Stored Procedure in SqlCE

问题描述

我刚刚安装了 Sql Server Compact Edition.令我惊讶的是，我们不能在 sql server CE 中使用存储过程.在 Sql Server CE 中，我有任何替代存储过程的方法吗?我对存储过程非常着迷，我想不出没有存储过程的应用程序.

I have just installed Sql Server Compact Edition. To my surprise, we can't use stored procedure in sql server CE. Do I have any alternative of Stored Procedure in Sql Server CE. I am strongly obsessed with stored procedure, I can'nt think of an application without stored procedures.

请帮忙，提前致谢.

我可以使用托管存储过程吗.

推荐答案

SqlCe 是供应用程序使用的本地数据库.不需要存储过程，因为数据库只是一个本地数据存储，业务逻辑在应用程序中.它不是发动机.如果您需要引擎，请使用 SqlExpress 或它的老大哥.在 http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact..它解释了您需要知道的一切.

SqlCe is a local database for use by an application. There is no need for stored procedures since the database is just a local data store, and the business logic is in the application. It is not an engine. If you need an engine then use SqlExpress or its big brother. See Steve Lasker's Comparing SQL Server Express and Compact Editions Whitepaper at http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc. It explains everything you need to know.

不，您不能使用托管存储过程.SqlCe 正在处理中.

No, you cannot use managed stored procedures. SqlCe is in-process.

此外，您可能会在 http://msdn.microsoft.com/en-us/library/bb380177(SQL.90).aspx 很有帮助.

Also, you might find Data Storage Architecture with SQL Server 2005 Compact Edition at http://msdn.microsoft.com/en-us/library/bb380177(SQL.90).aspx helpful.

这篇关于如何在SqlCE中使用存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！