Timothy Moore
Old Hand
Points: 314
More actions
January 22, 2007 at 12:13 pm
#175538
I have 1 column of data that i need to somehow get into a new column over in another table. Not sure on the syntax for the query on this. Any help? thanks
jezemine
SSCrazy Eights
Points: 8109
January 22, 2007 at 5:37 pm
#684823
insert into MyDestination (MyCol)
select MyCol from MySource
---------------------------------------elsasoft.org
Tim Mitchell
SSCoach
Points: 15685
January 23, 2007 at 9:15 pm
#685127
If you're moving from one database to another, remember to qualify your identifiers:
INSERT [db1].[dbo].[Table1] (my_column)
SELECT my_column FROM [db2].[dbo].[Table2]
Tim MitchellTimMitchell.net | @tmitch.net | Tyleris.comETL Best Practices
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply