Kizito Kizito - 1 year ago 65
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download