If a query with a query parameter like this is executed:
select *
from my_table
where id=@my_id
And the application supplies a query parameter value for a parameter with name id instead of my_id, the query is executed without any errors, and the value for the parameter my_id is null.
If a query with a query parameter like this is executed:
And the application supplies a query parameter value for a parameter with name
idinstead ofmy_id, the query is executed without any errors, and the value for the parametermy_idis null.