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?

Answer 1

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