Ask your own question, for FREE!
Computer Science 7 Online
OpenStudy (anonymous):

What are ad-hoc queries in SQL?

OpenStudy (anonymous):

Ad hoc is latin for "for this purpose". You might call it an "on the fly" query, or a "just so" query. It's the kind of SQL query you just loosely type out where you need it

OpenStudy (anonymous):

for example: var newSqlQuery = "SELECT * FROM table WHERE id = " + myId;

OpenStudy (anonymous):

which is an entirely different query each time that line of code is executed, depending on the value of myId. The opposite of an ad hoc query is a predefined query such as a Stored Procedure, where you have created a single query for the entire generalized purpose of selecting from that table (say), and pass the ID as a variable.

OpenStudy (anonymous):

Thanks that helped :)

OpenStudy (anonymous):

welcome :)

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!