How to insert a particular coulmn in table.

  • Thread starter Thread starter arunachalam.arcot
  • Start date Start date
A

arunachalam.arcot

I have a table, where i need to insert values only for one particular
column and teh other column will be manually or will be populated
through another queries. I'm kind of having difficuly in this. I tried
"Insert into " with select statements and also Select Inot, both does
not solve this, because they append a new row insted of inserting it in
a specific row. Any help will be highly appreciated.

Thanks
 
I have a table, where i need to insert values only for one particular
column and teh other column will be manually or will be populated
through another queries. I'm kind of having difficuly in this. I tried
"Insert into " with select statements and also Select Inot, both does
not solve this, because they append a new row insted of inserting it in
a specific row. Any help will be highly appreciated.
Click to expand...

Use the UPDATE statement. E.g.:

UPDATE table_name
SET column_name = some_value
WHERE <criteria>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to insert values in a particular column ONLY? 1
.adp Query with a function? 1
How to Populate Data from a table to another 0
Insert query 0
Using Append Queries with Linked Tables 3
Inserted Records not found in Linked table 1
trying to create a sample table with 31,000,000 rows 4
Insert a crosstab to temp table for report 6

Back
Top