Microsoft Query
 | This article needs additional citations for verification. (December 2009) |
Microsoft Query is a visual method of creating
database queries using examples based on a text string, the name of a document or a list of documents. The QBE system converts the user input into a formal database query using Structured Query Language (SQL) on the backend, allowing the user to perform powerful searches without having to explicitly compose them in SQL, and without even needing to know SQL. It is derived from Moshé M. Zloof's original Query by Example (QBE) implemented in the mid-1970s at IBM's Research Centre in Yorktown, New York.[1]
In the context of
database management system
for small businesses.
Microsoft Excel allows results of QBE queries to be embedded in spreadsheets.[2]
See also
References
- .
- ^ "Use Microsoft Query to retrieve external data". Office Support: Excel for Microsoft 365 Excel 2021, 2019, 2016, 2013, 2010, 2007. Microsoft.
External links
Wikibooks has a book on the topic of: Structured Query Language
Wikibooks has a book on the topic of: SQL dialects reference
| Others | ||
|---|---|---|
- Dynamics AX
- BASIC
- Visual Basic
- Bosque
- Visual C++
- C#
- C/AL
- Dafny
- Dexterity
- F#
- F*
- Visual FoxPro
- Java
- JavaScript
- IronPython
- IronRuby
- Lean
- P
- Power Fx
- PowerShell
- Project Verona
- Q#
- Small Basic
- VPL
- XAML
frameworks
| Native | |
|---|---|
| .NET | |
| Device drivers |
| SQL Server | |
|---|---|
| SQL services | |
| Other |
debugging
 | This article about software created, produced or developed by Microsoft is a stub. You can help Wikipedia by expanding it. |