msaccess-SQL视图-自动完成/intellisense或替代方式来编写查询? [英] msaccess - sql view - autocomplete / intellisense or alternate way to write queries?

问题描述

我对SQL有一些经验(仍在学习中)，但是我想开始使用MSAccess.

I have a bit of experience with SQL (still learning), but I want to start using MSAccess.

我想知道是否有一种更好的方法来编写SQL(不使用设计视图)，然后再使用SQL视图，因为它没有自动完成/智能感知功能.

I'm wondering if there is a better way to write SQL (without using design view) then using the SQL View as it doesn't have auto-complete / intellisense.

我本以为可以将其连接到SQL Server Management Studio，但是我可以编写查询，然后将其保留在MSAccess数据库中.

I was thinking that I could connect it to SQL server management studio, but I'd be able to write the query and then be able to keep it within the MSAccess database.

谢谢.

推荐答案

简短的回答:不，没有.

Short answer: No, there isn't.

但是；一个快速的google揭示了一些第三方实用程序，这些实用程序声称使开发SQL查询更容易-坦白地说，我怀疑它们是否很好.我怀疑的原因是，MS Access数据库作为文件构建"的方式与大多数大型数据库系统完全不同.像MySql和MS SQL这样的大型系统使获取正在使用的表的架构变得非常容易，因此实用程序可以在工作时获取该架构，并以Intellisense的形式向您展示.

But; a quick google reveals some third party utilities that claim to make developing SQL queries easier - to be honest, I doubt they're very good. The reason for my doubt, is that the way MS Access databases are "built" as a file is very different to most bigger database systems. Bigger systems like MySql and MS SQL make it very easy to get the schema of the tables you are working with, so utilities can get this schema as you are working and show it to you in the form of Intellisense.

但是，当我维护一些旧的MS Access应用程序"时，我曾经使用的是文本编辑器，例如Notepad ++，它具有一些基本的自动完成功能以及SQL语法突出显示功能.远非完美，但可以完成工作.

However, what I used to do when I was maintaining some legacy MS Access "Applications" was to use a text editor like Notepad++, which has some rudimentary autocomplete functionality, as well as SQL syntax highlighting. Far from perfect, but it got the job done.

这篇关于msaccess-SQL视图-自动完成/intellisense或替代方式来编写查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！