对齐Microsoft Access查询 [英] Align microsoft access queries

问题描述

每次，我都必须从控件的[record source]属性的MSAccess复制查询，并粘贴在记事本中以使其对齐，以便我可以读取它.

Each time I have to copy a query from MSAccess from a control's [record source] property and paste in notepad to align it just so I can read it.

我曾经使用Ctrl + R用换行符替换逗号，但是现在忘记了换行符是什么.您以前是否使用过此功能，如果可以，我如何获得换行符?

I once used Ctrl+R to replace commas with newline characters but now forgot what the newline character is. Have you used this before, if so how can I get the newline character?

更好的是，有没有一种工具可以自动对齐MSAccess或任何Microsoft数据库工具中的SQL.

Better yet, is there a tool to auto align SQL from MSAccess or any of the Microsoft database tools.

干杯.

推荐答案

此在线服务漂亮"为您格式化SQL 漂亮的SQL格式化程序，或者您可以尝试使用 Notepad ++ 替换记事本；这包括搜索和替换扩展"字符并用换行符替换它们的功能.

This online service "pretty" formats SQL for you Pretty SQL formatter or you could try using the Notepad++ replacement for Notepad; this includes a facility to search and replace for "extended" characters and replace them with newlines.

这篇关于对齐Microsoft Access查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！