I am a newbie to databases and MSSQL. I have successfully added records to my tables in MSSQL by using the DTS Import/Export wizard.
I am having great difficulty in updating records. I wanted to use the DTS Import/Export wizard but it's not built to handle updates. I have successfully used the SQL Query Analyzer but it takes me forever to build the queries using queries within quieries. Here's an example of an update query I built.
My scenario is as follows. I have records already in a database. I then have updates that need to be applied to these records. I need a simpler method of applying a text file to existing records. Any ideas.
I am having great difficulty in updating records. I wanted to use the DTS Import/Export wizard but it's not built to handle updates. I have successfully used the SQL Query Analyzer but it takes me forever to build the queries using queries within quieries. Here's an example of an update query I built.
Code:
update products
set products.option1 = (select option1 from product_category_temp
where product_category_temp.product_ID = products.product_ID)