Hi ..
If the table structure is same yo u can also use insert into select * from format.
The usage is that you can create the dynamic query and then run them at one go so that it would be easier
select "insert into " + name form sysobjects where type ='U'
tyeps
U can as well use DTS
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.