如何将SQL查询转换为MS.Access [英] How to convert sql queries to MS.access

问题描述

大家好，
我已经开发了Windows应用程序，并且使用的数据库是mssql，现在我想更改数据库以进行访问，我可以更改sql存储的过程来进行访问吗?我对此一无所知，任何人都知道解决方案，请帮助我.
谢谢.

Hi everybody,
I have developed a windows application, and in that the database that used is mssql, and now i want change the database to access, can i change the sql stored proceedurs to access? i dont have any idea about this, anyone know the solution, pls help me.
Thanking you.

推荐答案

如果存储过程在数据库本身中，则必须重写它们.如果它们在应用程序中，则在大多数情况下(通过一些调整)，您应该能够更改数据库提供程序，然后就可以使用了.我想.

If the stored procedures are in the database itself, you''ll have to rewrite them. If they''re in the application, for the most part(with some tweaking), you should be able to just change database providers and off you go. I think.

这篇关于如何将SQL查询转换为MS.Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！