Populating Tables In SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Populating Tables In SQL Server

Author

Topic

murtzzz
Starting Member

14 Posts

Posted - 2007-03-07 : 04:23:24

Hi.. Im new to these forums!

I've created some new tables in SQL Analyzer.. and Im trying to automatically populate some of the fields from an existing database instead of populating the table with INSERT INTO statements.

Please help.. because I dont even know how to get started on it at the moment!

Thanks

Murtz

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2007-03-07 : 04:34:04

INSERT INTO TableA (Field1, Field2, etc)
SELECT (Field1, Field2, etc)
FROM TableB
WHERE [Some Conditions]

Mark

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-07 : 04:35:00

[code]
insert into newtable(cola, colb, colc)
select col1, col2, col3
from sometable
[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources