Passing parameters to Stored Procedure without @ symbol

Question

Well, Im curious what will happen if i pass some parameters without @ symbol

public static int Run(string command,string anotherParameter, DataTable dt)
 {
   SqlDataAdapter adapter = new SqlDataAdapter("SPName", Connection.Connect);
   adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
   adapter.SelectCommand.Parameters.Add("@command",SqlDbType.NVarChar).Value=command;

   //another one without @        
   adapter.SelectCommand.Parameters.Add("anotherParameter",SqlDbType.NVarChar).Value=anotherParameter;
     try
        {

            return adapter.Fill(dt);
        }
     catch (Exception ex)
        {
            return -1;
        }
        finally
        {
            adapter.Dispose();
        }     

 }

this may run sometimes and failed another?

Thanks

@Mido Fairly certain we have some code that specifies `@` and some that doesn't. Both work. — Adam Houldsworth, Apr 22 '13 at 09:17
@Garath well, i tried it yes, but i noticed that it works sometimes and sometimes not. — dotmido, Apr 22 '13 at 09:19

score 1 · Answer 1 · answered Apr 22 '13 at 09:24

If you don't add "@" before parameter name, the "@" is added automatically.But good practice is to manually add @ and do not rely on automatic functionality. See http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.parametername.aspx for more information

Passing parameters to Stored Procedure without @ symbol

1 Answers1