copy all Data From one Table to another with same Structure
insert into [MyDB].[dbo].[Emp] select * from [Info].[dbo].[A]
it will copy all data in EMP table from A Table
Showing posts with label Copy all Data From one Table to another with same Structure in sql. Show all posts
Showing posts with label Copy all Data From one Table to another with same Structure in sql. Show all posts
Monday, October 18, 2010
Subscribe to:
Posts (Atom)