append to table, sql 2000

[powerprinting]

Hope you can help me. We lost an employee who is well versed in sql server 2000. I am assigned the task to rescue a job we have. He set up an web based program for us that incorporates the use of a database containing 8 tables. All the functions work well, the web site runs fine also. My problem is how to append additional data to only one of the tables in the database maybe two. My primary question is do I use Enterprise manager... this doesn't seem to be the case as far as I can tell.. or do I need to use the Query Analyzer? Also, it is a maze to me.. I know Foxpro but not versed in SQL 2000. Can you point me in the right direction? Am I in over my head? Thanks for any help

 

[john76]

I am not sure I completely understand your situation, but if you are simply inserting new data into the tables and not changing anything structurally to the database then it should be as simple as:

INSERT INTO database.owner.tablename (field1, field2, etc.)
  VALUES (value1, value2, etc.)

or...

INSERT INTO database.owner.tablename (field1, field2, etc.)
  SELECT  field1, field2, etc.
  FROM  database.owner.othertablename

If this is not what you are after, can you elaborate?

HTH,
John

 

[powerprinting]

No, not changing any structures. This is a good start. What utility is it I use? Query analyzer?

 

[john76]

The code I typed above represents what you would type into query analyzer.

John