Insert into another table - SQL Server Forums

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)

Insert into another table

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-16 : 08:42:14

Kenneth writes "I have one table (register) with the identity columns ob_id, text and url. My mission is to copy information from 2 different tables. I.e.

table 1 which holds the url info :

insert into REGISTER (url)
select top 1 tekst
from url
where tekst like '%'

table 1 which holds the text info :

insert into REGISTER (headline)
select top 1 tekst
from text
where tekst like '%'

How is it possible that both of the top info in the different tables can paste the information in the same register row (ob_id)?"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources