Viewing post 1 (of 2 total)
use this query to insert tablestrecture and data in another database
select * into newtablename from old-databasename.dbo.existingtable-name
example
old database is====employee and table name is -- employeedetails
new database is===emp ...
April 7, 2008 at 9:37 pm
#799528