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
 General SQL Server Forums
 New to SQL Server Programming
 appending to a table

Author  Topic 

rjhe22
Constraint Violating Yak Guru

283 Posts

Posted - 2013-03-14 : 10:48:05
if i want to append data from one table to another is that basically just an insert

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2013-03-14 : 11:10:05
insert TableX(col1, col2, col3)
select col1,col2,col3 from TableY


Too old to Rock'n'Roll too young to die.
Go to Top of Page
   

- Advertisement -