Comparison With Prepared Statements
Prepared statements take an ordinary statement or query and parameterize it so that different literal values can be used at a later time. Like stored procedures, they are stored on the server for efficiency and provide some protection from SQL injection attacks. Although simpler and more declarative, prepared statements are not ordinarily written to use procedural logic and cannot operate on variables. Because of their simple interface and client-side implementations, prepared statements are more widely reusable between DBMSs.
Read more about this topic: Stored Procedure
Famous quotes containing the words comparison with, comparison, prepared and/or statements:
“I have travelled a good deal in Concord; and everywhere, in shops, and offices, and fields, the inhabitants have appeared to me to be doing penance in a thousand remarkable ways.... The twelve labors of Hercules were trifling in comparison with those which my neighbors have undertaken; for they were only twelve, and had an end; but I could never see that these men slew or captured any monster or finished any labor.”
—Henry David Thoreau (1817–1862)
“Most parents aren’t even aware of how often they compare their children. . . . Comparisons carry the suggestion that specific conditions exist for parental love and acceptance. Thus, even when one child comes out on top in a comparison she is left feeling uneasy about the tenuousness of her position and the possibility of faring less well in the next comparison.”
—Marianne E. Neifert (20th century)
“Now for civil service reform. Legislation must be prepared and executive rules and maxims. We must limit and narrow the area of patronage. We must diminish the evils of office-seeking. We must stop interference of federal officers with elections. We must be relieved of congressional dictation as to appointments.”
—Rutherford Birchard Hayes (1822–1893)
“There was books too.... One was “Pilgrim’s Progress,” about a man that left his family it didn’t say why. I read considerable in it now and then. The statements was interesting, but tough.”
—Mark Twain [Samuel Langhorne Clemens] (1835–1910)