Definition - What does Parameterized Query mean?
A parameterized query is a type of SQL query that requires at least one parameter for execution. A placeholder is normally substituted for the parameter in the SQL query. The parameter is then passed to the query in a separate statement.
Techopedia explains Parameterized Query
One major reason for using parameterized queries is that they make queries more readable. The second and most compelling reason is that parameterized queries help to protect the database from SQL injection attacks.
The following is an example of an ADO.NET parameterized query:
SELECT LastName FROM Contacts WHERE ContactID = @ContactID;
@ContactID is the parameter for this query, which might be defined in a subsequent statement similar to the following:
command.Parameters.Add(new SqlParameter("@ContactID", theContactID));
Techopedia Deals: Oracle Database 12c Administration Training Bundle
Join thousands of others with our weekly newsletter
The 4th Era of IT Infrastructure: Superconverged Systems:
Approaches and Benefits of Network Virtualization:
Free E-Book: Public Cloud Guide:
Free Tool: Virtual Health Monitor:
Free 30 Day Trial – Turbonomic: