You can use SELECT...INTO as documented at http://msdn2.microsoft.com/en-us/library/ms190750.aspx. Just identify your table using four part naming so that you can direct it to the table in the other database.
Regards,
Mike Wachal
SQL Express team
-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1
No comments:
Post a Comment