Glossary entry (derived from question below)
German term or phrase:
zusammenstellen
English translation:
compose
Added to glossary by
Steffen Walter
Dec 4, 2008 10:32
15 yrs ago
1 viewer *
German term
Germany
Scientific & technical expertise
Native in: English (Variant: British) 
Works in: German to English
eine SQL-Klausel zusammenstellen
German to English
Tech/Engineering
Computers: Software
SQL
I'm puzzled by this usage of zusammenstellen (slightly paraphrased):
"(Man) kann selbst Datenbankfilter konfigurieren, indem man eine SQL-Klausel für die Datenbankabfrage zusammenstellt oder manuell eingibt."
I'm also a bit puzzled by what an "SQL-Klausel" is meant to be, other than an "SQL query". My draft translation:
You can configure database filters yourself by compiling an SQL database query command or entering one manually.
Although I'm sure compiling is wrong.
"(Man) kann selbst Datenbankfilter konfigurieren, indem man eine SQL-Klausel für die Datenbankabfrage zusammenstellt oder manuell eingibt."
I'm also a bit puzzled by what an "SQL-Klausel" is meant to be, other than an "SQL query". My draft translation:
You can configure database filters yourself by compiling an SQL database query command or entering one manually.
Although I'm sure compiling is wrong.
Proposed translations
(English)
| 4 | compose |
Aidan Cosgrove (X)
|
| 4 | formulate an SQL clause |
Ken Cox
|
Change log
Dec 29, 2008 09:55: Steffen Walter changed "Term asked" from "(einen SQL-Klausel) zusammenstellen" to "eine SQL-Klausel zusammenstellen"
Dec 29, 2008 09:55: Steffen Walter changed "Edited KOG entry" from "<a href="/profile/62748">David Williams's</a> old entry - "(einen SQL-Klausel) zusammenstellen"" to ""compose""
Proposed translations
24 mins
German term (edited):
(einen SQL-Klausel) zusammenstellen
Selected
compose
SQL queries are sometimes put together using a GUI dialog or form, rather than maually.
So the term zusammenstellen is not strictly SQL-specific. It probably means building, assembling, or composing an SQL clause using a form rather than manually.
So the term zusammenstellen is not strictly SQL-specific. It probably means building, assembling, or composing an SQL clause using a form rather than manually.
4 KudoZ points awarded for this answer.
Comment: "Ah! Thanks Aidan! Seems so obvious now. At least compiling wasn't TOO far off the mark."
20 mins
German term (edited):
(einen SQL-Klausel) zusammenstellen
formulate an SQL clause
Based on the MS terminology website, a Klausel in SQL is a clause, e.g.:
DELETE clause DELETE-Klausel A part of a DML Statement that contains the DELETE keyword and associated parameters. SQL Server
refs:
http://www.microsoft.com/language/en/us/search.mspx
SQL injection
The SQL clause HAVING is used to filter records returned by GROUP BY. ... schema used to hold user information, he can formulate a query to add his user: ...
searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1125858,00.html
Query DB2 XML Data with SQL
16 Mar 2006 ... The first line is an SQL clause specifying that you only want to retrieve .... While there are different ways to formulate such joins, ...
www.ibm.com/developerworks/db2/library/techarticle/dm-0603s...
--------------------------------------------------
Note added at 23 mins (2008-12-04 10:56:33 GMT)
--------------------------------------------------
Of course, you could also use 'compose'.
DELETE clause DELETE-Klausel A part of a DML Statement that contains the DELETE keyword and associated parameters. SQL Server
refs:
http://www.microsoft.com/language/en/us/search.mspx
SQL injection
The SQL clause HAVING is used to filter records returned by GROUP BY. ... schema used to hold user information, he can formulate a query to add his user: ...
searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1125858,00.html
Query DB2 XML Data with SQL
16 Mar 2006 ... The first line is an SQL clause specifying that you only want to retrieve .... While there are different ways to formulate such joins, ...
www.ibm.com/developerworks/db2/library/techarticle/dm-0603s...
--------------------------------------------------
Note added at 23 mins (2008-12-04 10:56:33 GMT)
--------------------------------------------------
Of course, you could also use 'compose'.
Note from asker:
| Very many thanks Ken! |
Discussion
In diesem Beispiel wird die Suche nur auf die Spalte DEUTSCH der Datensätze beschränkt.