I need to get a value from a field on front end application that is connected to the DB. The thing is I would like to insert the single value entered into One column in a table that has multiple columns.
You can declare the field that you'd like to insert data into like this;
INSERT INTO Table (field) VALUES (@datapassedin)
It gets more complicated when you want to UPDATE but I don't believe that's your question.