Adding SQL Parameters in C#

Question

What is the difference between:

myCommand.Parameters.AddWithValue("search", "% " + myValue + " %");

and:

myCommand.Parameters.AddWithValue("@search", "% " + myValue + " %");

The difference above is with and without the @ symbol. Does it do anything special?

tom · Accepted Answer · 2012-12-22 03:09:32Z

4

You need to use the variant with the '@'. The '@' symbol signifies a variable or a stored procedure / function parameter.

answered Dec 22, 2012 at 3:09

tom

19.3k4 gold badges39 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kazem · Accepted Answer · 2012-12-22 04:17:46Z

0

in sql stored procs or functions you must specify parameters name by '@' sign at the beginning of their name

answered Dec 22, 2012 at 4:17

kazem

3,7691 gold badge24 silver badges22 bronze badges