Kizito Kizito - 6 months ago 11
SQL Question

How do I insert one value into one column?

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.

Answer

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.