Learned by Reading
In the ICWSM 2009 Weblog Corpus:
I am writing a rather complex query that uses several conditional satements.
(Parse)
(S1 (S (NP (PRP I))
(VP (AUX am)
(VP (VBG writing)
(NP (NP (DT a)
(ADJP (RB rather) (JJ complex)) (NN query))
(SBAR (WHNP (WDT that))
(S (VP (VBZ uses)
(NP (JJ several) (JJ conditional) (NNS satements)))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
I’m trying to call all my topics with 1 database call, so I am writing a nice, concise sql query.
(Parse)
(S1 (S (S (NP (PRP I))
(VP (AUX 'm)
(VP (VBG trying)
(S (VP (TO to)
(VP (VB call)
(NP (PDT all) (PRP$ my) (NNS topics))
(PP (IN with)
(NP (CD 1) (NN database) (NN call)))
(, ,) (CC so)
(S (NP (PRP I))
(VP (AUX am)
(VP (VBG writing)
(NP (DT a) (JJ nice) (, ,) (JJ concise) (JJ sql) (NN query)))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
I am writing a rather complex query that uses several conditional satements.
(Parse)
(S1 (S (NP (PRP I))
(VP (AUX am)
(VP (VBG writing)
(NP (NP (DT a)
(ADJP (RB rather) (JJ complex)) (NN query))
(SBAR (WHNP (WDT that))
(S (VP (VBZ uses)
(NP (JJ several) (JJ conditional) (NNS satements)))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
I can write queries… however, when I write code in button click to send data from VC # to SQL, it does not go to SQL. it executes the statement (I know because there is no error and runs the next messagebox statement).
(Parse)
(S1 (S (S (NP (PRP I))
(VP (MD can)
(VP (VB write)
(NP (NNS queries)) (ADVP (RB ..)))))
(. .) (ADVP (RB however)) (, ,)
(SBAR (WHADVP (WRB when))
(S (NP (PRP I))
(VP (VBP write)
(NP (NN code))
(SBAR (IN in) (NN button)
(S (NP (NN click))
(VP (TO to)
(VP (VB send)
(NP (NP (NNS data))
(PP (IN from)
(NP (NN VC))))
(NP (QP (# #) (TO to) (NN SQL)))
(, ,)
(S (NP (PRP it))
(VP (AUX does) (RB not)
(VP (VB go)
(PP (TO to)
(NP (NNP SQL)))))
(. .)))
(NP (PRP it))
(VP (VBZ executes)
(NP (NP (DT the) (NN statement)) (PRN (-LRB- -LRB-)
(S (NP (PRP I))
(VP (VBP know)
(SBAR (IN because)
(S (NP (EX there))
(VP (VP (AUX is)
(NP (DT no) (NN error)))
(CC and)
(VP (VBZ runs)
(NP (DT the) (JJ next) (NN messagebox) (NN statement)))))
(-RRB- -RRB-))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
I am more familiar with MSSQL, but in there you could write queries…
(Parse)
(S1 (S (S (NP (PRP I))
(VP (AUX am)
(ADJP (RBR more) (JJ familiar)
(PP (IN with)
(NP (NNP MSSQL)))
(, ,) (CC but)
(S (PP (IN in)
(NP (RB there)))
(NP (PRP you))
(VP (MD could)
(VP (VB write)
(NP (NNS queries)) (ADVP (RB ..)))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
I can write queries… however, when I write code in button click to send data from VC # to SQL, it does not go to SQL. it executes the statement (I know because there is no error and runs the next messagebox statement).
(Parse)
(S1 (S (S (NP (PRP I))
(VP (MD can)
(VP (VB write)
(NP (NNS queries)) (ADVP (RB ..)))))
(. .) (ADVP (RB however)) (, ,)
(SBAR (WHADVP (WRB when))
(S (NP (PRP I))
(VP (VBP write)
(NP (NN code))
(SBAR (IN in) (NN button)
(S (NP (NN click))
(VP (TO to)
(VP (VB send)
(NP (NP (NNS data))
(PP (IN from)
(NP (NN VC))))
(NP (QP (# #) (TO to) (NN SQL)))
(, ,)
(S (NP (PRP it))
(VP (AUX does) (RB not)
(VP (VB go)
(PP (TO to)
(NP (NNP SQL)))))
(. .)))
(NP (PRP it))
(VP (VBZ executes)
(NP (NP (DT the) (NN statement)) (PRN (-LRB- -LRB-)
(S (NP (PRP I))
(VP (VBP know)
(SBAR (IN because)
(S (NP (EX there))
(VP (VP (AUX is)
(NP (DT no) (NN error)))
(CC and)
(VP (VBZ runs)
(NP (DT the) (JJ next) (NN messagebox) (NN statement)))))
(-RRB- -RRB-))))
(. .)))
In Wikipedia:
This portion of Core Data is similar to the original EOF system, in that one can write fairly sophisticated queries.
(Parse)
(S1 (S (NP (NP (DT This) (NN portion))
(PP (IN of)
(NP (NNP Core) (NNP Data))))
(VP (AUX is)
(ADJP (JJ similar)
(PP (TO to)
(NP (DT the) (JJ original) (NN EOF) (NN system))))
(, ,)
(SBAR (IN in) (IN that)
(S (NP (PRP one))
(VP (MD can)
(VP (VB write)
(NP (ADJP (RB fairly) (JJ sophisticated)) (NNS queries))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
No DBA will take your seriously if you write queries like this: SELECT Column1, Column2 FROM Table1 t1, Table2 t2 WHERE t1. Column3 = t2. Column3…
(Parse)
(S1 (FRAG (S (NP (DT No) (NN DBA))
(VP (MD will)
(VP (VB take)
(NP (PRP$ your)) (ADVP (RB seriously))
(SBAR (IN if)
(S (NP (PRP you))
(VP (VBP write)
(NP (NP (NNS queries))
(PP (IN like)
(NP (DT this))))
(: :)
(NP (NP (NNP SELECT) (NNP Column1) (, ,) (NNP Column2))
(PP (IN FROM)
(NP (NNP Table1) (JJ t1))))
(, ,)
(NP (NNP Table2) (CD t2)) (WHADVP (WRB WHERE) (JJ t1)) (. .)
(NP (NNP Column3)) (X (SYM =))
(NP (NN t2)) (. .)
(NP (NNP Column3) (CD ..)) (. .)))
In the ICWSM 2009 Weblog Corpus:
I was working on the last part of the SQL bits when I wrote a query to do a very general and easy thing.
(Parse)
(S1 (S (NP (PRP I))
(VP (AUX was)
(VP (VBG working)
(PP (IN on)
(NP (NP (DT the) (JJ last) (NN part))
(PP (IN of)
(NP (DT the) (NNP SQL) (NNS bits)))))
(SBAR (WHADVP (WRB when))
(S (NP (PRP I))
(VP (VBD wrote)
(NP (DT a) (NN query)
(S (VP (TO to)
(VP (AUX do)
(NP (DT a)
(ADJP (RB very) (JJ general) (CC and) (JJ easy)) (NN thing)))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
We need to get a reference to our DataContext from earlier, and then I wrote a simple query to retrieve names from the database based on a last name query.
(Parse)
(S1 (S (S (NP (PRP We))
(VP (AUX need)
(S (VP (TO to)
(VP (VB get)
(NP (NP (DT a) (NN reference))
(PP (TO to)
(NP (PRP$ our) (NN DataContext))))
(PP (IN from) (ADVP (RB earlier)))))
(, ,) (CC and)
(S (ADVP (RB then))
(NP (PRP I))
(VP (VBD wrote)
(NP (DT a) (JJ simple) (NN query)
(S (VP (TO to)
(VP (VB retrieve)
(NP (NNS names))
(PP (IN from)
(NP (NP (DT the) (NN database))
(VP (VBN based)
(PP (IN on)
(NP (DT a) (JJ last) (NN name) (NN query)))
(. .)))
In the ICWSM 2009 Weblog Corpus:
September 2008 This month Toolbox provides help with error logging, finds an app that helps you write LINQ queries, and explores the non – technical side of development.
(Parse)
(S1 (S (NP (NP (NNP September) (CD 2008))
(NP (DT This) (NN month)) (NNP Toolbox))
(VP (VP (VBZ provides)
(NP (NN help))
(PP (IN with)
(NP (NN error) (VBG logging))))
(, ,)
(VP (VBZ finds)
(NP (NP (DT an) (NN app))
(SBAR (WHNP (WDT that))
(S (VP (VBZ helps)
(S (NP (PRP you))
(VP (VB write)
(NP (NNP LINQ) (NNS queries)))
(, ,) (CC and)
(VP (VBZ explores)
(NP (NP (DT the) (NN non)) (: -)
(NP (NP (JJ technical) (NN side))
(PP (IN of)
(NP (NN development))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
Because ExecuteSql takes an arbitrary query, you can define a policy that monitors literally any aspect of server health that you can write a query to detect.
(Parse)
(S1 (S (SBAR (IN Because)
(S (NP (NNP ExecuteSql))
(VP (VBZ takes)
(NP (DT an) (JJ arbitrary) (NN query)))))
(, ,)
(NP (PRP you))
(VP (MD can)
(VP (VB define)
(NP (NP (DT a) (NN policy))
(SBAR (WHNP (WDT that))
(S (VP (VBZ monitors)
(NP (NP (RB literally) (DT any) (NN aspect))
(PP (IN of)
(NP (JJ server) (NN health)))
(SBAR (IN that)
(S (NP (PRP you))
(VP (MD can)
(VP (VB write)
(NP (DT a) (NN query)
(S (VP (TO to)
(VP (VB detect))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
On the other hand, if I write a query like
(Parse)
(S1 (S (PP (IN On)
(NP (DT the) (JJ other) (NN hand)))
(, ,)
(SBAR (IN if)
(S (NP (PRP I))
(VP (VBP write)
(NP (DT a) (NN query))
(PP (IN like)))))))
In the ICWSM 2009 Weblog Corpus:
Knowing SQL lets you write a single query to answer questions like, “What’s the average total for orders received from customers in Texas over each of the last six months?
(Parse)
(S1 (S (NP (VBG Knowing) (NN SQL))
(VP (VBZ lets)
(S (NP (PRP you))
(VP (VB write)
(NP (DT a) (JJ single) (NN query)
(S (VP (TO to)
(VP (VB answer)
(NP (NNS questions)))
(PP (IN like)))
(, ,) ('' ')))
(: ') (SBARQ (WHNP (WP What)) (SQ (VP (AUX 's)
(NP (NP (DT the) (JJ average) (NN total))
(PP (IN for)
(NP (NP (NNS orders))
(VP (VBN received)
(PP (IN from)
(NP (NP (NNS customers))
(PP (IN in)
(NP (NNP Texas)))))
(PP (IN over)
(NP (NP (DT each))
(PP (IN of)
(NP (DT the) (JJ last) (CD six) (NNS months)))))
(. ?))))
In the ICWSM 2009 Weblog Corpus:
You can write a very small LINQ query to retrieve the contents of content controls.
(Parse)
(S1 (S (NP (PRP You))
(VP (MD can)
(VP (VB write)
(NP (DT a)
(ADJP (RB very) (JJ small)) (NNP LINQ) (NN query)
(S (VP (TO to)
(VP (VB retrieve)
(NP (NP (DT the) (NNS contents))
(PP (IN of)
(NP (NN content) (NNS controls))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
I wrote a short query in prose on Monday night, just a few words down on paper that made me feel better and I realised that instead of not writing anything because it’s too big, too daunting, I should just write.
(Parse)
(S1 (S (NP (PRP I))
(VP (VBD wrote)
(NP (DT a) (JJ short) (NN query))
(PP (IN in)
(NP (NN prose)))
(PP (IN on)
(NP (NNP Monday) (NN night)))
(, ,) (ADVP (NP (RB just) (DT a) (JJ few) (NNS words)) (IN down))
(PP (IN on)
(NP (NN paper)))
(SBAR (IN that)
(S (VP (VBD made)
(S (NP (PRP me))
(VP (VB feel) (ADVP (RB better))
(S (CC and)
(NP (PRP I))
(VP (VBD realised)
(SBAR (IN that)
(S (PP (RB instead) (IN of)
(S (RB not)
(VP (VBG writing)
(NP (NN anything))
(SBAR (IN because)
(S (NP (PRP it))
(VP (AUX 's)
(ADJP (ADJP (RB too) (JJ big)) (, ,)
(ADJP (RB too) (JJ daunting)))
(, ,)
(NP (PRP I))
(VP (MD should) (ADVP (RB just))
(VP (VB write))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
When you are writing queries for the helpdesk you often may need to know a contact ID or a worker / queue ID.
(Parse)
(S1 (S (SBAR (WHADVP (WRB When))
(S (NP (PRP you))
(VP (AUX are)
(VP (VBG writing)
(NP (NNS queries))
(PP (IN for)
(NP (DT the) (NN helpdesk))))
(NP (PRP you)) (ADVP (RB often))
(VP (MD may)
(VP (AUX need)
(S (VP (TO to)
(VP (VB know)
(NP (NP (DT a) (NN contact) (NN ID)) (CC or)
(NP (DT a) (NN worker) (NN /) (NN queue) (NN ID)))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
Since SQL Server 2008 is not RTM, and since facets can be added in the future, I thought I’d write a query that would list the facets and supported evaluation modes.
(Parse)
(S1 (S (SBAR (SBAR (IN Since)
(S (NP (NNP SQL) (NNP Server) (CD 2008))
(VP (AUX is) (RB not)
(ADJP (JJ RTM)))))
(, ,) (CC and)
(SBAR (IN since)
(S (NP (NNS facets))
(VP (MD can)
(VP (AUX be)
(VP (VBN added)
(PP (IN in)
(NP (DT the) (NN future)))
(, ,)
(NP (PRP I))
(VP (VBD thought)
(SBAR (S (NP (PRP I))
(VP (MD 'd)
(VP (VB write)
(NP (NP (DT a) (NN query))
(SBAR (WHNP (WDT that))
(S (VP (MD would)
(VP (VB list)
(NP (NP (DT the) (NNS facets)) (CC and)
(NP (VBN supported) (NN evaluation) (NNS modes))))
(. .)))
In the ICWSM 2009 Weblog Corpus:
I often write queries in Access to aggregate data based on certain criteria.
(Parse)
(S1 (S (NP (PRP I)) (ADVP (RB often))
(VP (VBP write)
(NP (NNS queries))
(PP (IN in)
(NP (NP (NN Access))
(PP (TO to)
(NP (NP (JJ aggregate) (NNS data))
(VP (VBN based)
(PP (IN on)
(NP (JJ certain) (NNS criteria)))
(. .)))
And 125 more sentences.