By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Am i able to insert into a table data from a temp table?

P: 1
i have split a database into two exact copies one for internal customer the other for external and they have started to right to there own copy.

the problem i have is some of the external cutomers where able to write to the internal database for a short period of time.

i want to know the easiest way to get the data out of one database to another. the table and column names are identical.

i have abstracted the data into temp tables and wanted to know if it is possible to the insert this into the other database. if not then any other ideas??

many thanks

Aug 5 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 145
You can combine the two easily, just use SELECT INTO.

Expand|Select|Wrap|Line Numbers
  1. SELECT [column1],[column2],[column#] INTO [mySchema].[myPermTable] FROM [mySchema].[myTempTable]
I know you probably already know all about SELECT statements but this link is definitely worth reading.
Aug 5 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.