deleteCommand的sql语句正确吗？

Question

"delete  from users where ID=@ID"
deleteCustomerComm.Parameters.Add("@job_id",SqlDbType.SmallInt,2,"job_id");
deleteCommand的sql语句正确吗？

Answer 1

deleteCustomerComm.Parameters.Add("@job_id",SqlDbType.SmallInt,2).Value = "job_id";

Answer 2

"delete  from users where ID=@ID" //这是 @ID
deleteCustomerComm.Parameters.Add("@job_id",SqlDbType.SmallInt,2,"job_id");
//这里变成"@job_id"了？

Answer 3

deleteCustomerComm.Parameters.Add("@id",SqlDbType.SmallInt,2).Value = "job_id";