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:
“What is man in nature? A nothing in comparison with the infinite, an all in comparison with the nothing—a mean between nothing and everything.”
—Blaise Pascal (1623–1662)
“It is comparison than makes people miserable.”
—Chinese proverb.
“And ladies with their nails prepared for tea
And sunken barques that coast the shores of hell
And old men vacant of propriety
Have faintly rung a next-door neighbor’s bell.”
—Allen Tate (1899–1979)
“In so far as the statements of geometry speak about reality, they are not certain, and in so far as they are certain, they do not speak about reality.”
—Albert Einstein (1879–1955)