tag:blogger.com,1999:blog-495177919198719500.post8124544737471995593..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Copy a table from one database to another in SQL Server 2005Suprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-495177919198719500.post-48019281557229828492012-05-30T02:14:48.044-07:002012-05-30T02:14:48.044-07:00thanks but my databases are present on different m...thanks but my databases are present on different machine (server) then what should i do?<br /><br /><br />my email ID is : aju184@gmail.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-50289888396735124142012-05-30T02:13:46.690-07:002012-05-30T02:13:46.690-07:00thanks but my databases are present on different m...thanks but my databases are present on different machine (server) then what should i do?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-49425722554170262222012-05-26T03:02:49.918-07:002012-05-26T03:02:49.918-07:00thanks alot dear......thanks alot dear......Anonymoushttps://www.blogger.com/profile/08753620357760937050noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-59618181523000935662011-11-03T23:31:23.988-07:002011-11-03T23:31:23.988-07:00Hi,
http://hightechpost.blogspot.com/2011/10/copy...Hi,<br /><br />http://hightechpost.blogspot.com/2011/10/copying-table-in-sql-server-2005.html<br /><br />check it in simple way for:<br /><br />1)Copy table from same Database:<br /><br />2)Copy table from another Database:<br /><br />3)Copy few columns into the destination table:<br /><br />regards<br />hightechpostRahulhttps://www.blogger.com/profile/05352170641847175041noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-67761843950745528002011-02-12T00:40:51.007-08:002011-02-12T00:40:51.007-08:00insert into Suprotim_Agarwal_comments values('...insert into Suprotim_Agarwal_comments values('Thanks a lot bro');Unknownhttps://www.blogger.com/profile/01306061696534897850noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-52819658675840532612011-01-14T14:47:11.071-08:002011-01-14T14:47:11.071-08:00Thanks, dude. Still helpful.Thanks, dude. Still helpful.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-8254058221104738512010-12-10T12:55:49.245-08:002010-12-10T12:55:49.245-08:00Thank you! PerfectThank you! PerfectAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-86888277044212204372010-12-03T08:59:47.086-08:002010-12-03T08:59:47.086-08:00Thanks ! ! ! ! !Thanks ! ! ! ! !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-29394477375649832382010-10-13T14:51:22.877-07:002010-10-13T14:51:22.877-07:00Thank you!
- venkyThank you!<br /><br /> - venkyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-57798031868751739762010-06-21T00:38:01.655-07:002010-06-21T00:38:01.655-07:00Thanks, it works!Thanks, it works!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-38169003799303597242010-05-25T10:08:57.020-07:002010-05-25T10:08:57.020-07:00From db2, type this in your query analyzer:
INSER...From db2, type this in your query analyzer:<br /><br />INSERT INTO copytable SELECT * FROM db1.dbo.origtable<br /><br />...........................ThankyouSankarnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-33855133082416805972010-04-21T12:43:21.548-07:002010-04-21T12:43:21.548-07:00Thank you for sharing knowledge and helping others...Thank you for sharing knowledge and helping others with it.<br /><br />AmirAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-24814557243272230172010-03-27T09:35:17.686-07:002010-03-27T09:35:17.686-07:00Thankyou so much buddy, I tried in many ways to ge...Thankyou so much buddy, I tried in many ways to get this done, but finally your solution helped me.<br /><br />Nice blog.Sivanoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-75762754791371492292010-02-25T05:26:41.615-08:002010-02-25T05:26:41.615-08:00thanks buddythanks buddyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-57761688065662424442009-12-04T23:40:59.470-08:002009-12-04T23:40:59.470-08:00thank uthank uAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-14323358093868515692009-11-10T17:59:15.683-08:002009-11-10T17:59:15.683-08:00Thanks for the post.Thanks for the post.vnasibihttps://www.blogger.com/profile/06118475747572419860noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-75968694434558847792009-10-07T02:22:00.865-07:002009-10-07T02:22:00.865-07:00it creates a new table. i want to copy just data f...it creates a new table. i want to copy just data from one table to anotherAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-49729065815504256742009-08-06T23:42:56.129-07:002009-08-06T23:42:56.129-07:00Thanx it really saved my time and effortThanx it really saved my time and effortAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-17426750757300238932009-07-20T07:26:40.402-07:002009-07-20T07:26:40.402-07:00Thanks for the Help!Thanks for the Help!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-57438291491714960492009-02-04T03:15:00.000-08:002009-02-04T03:15:00.000-08:00Thanks for this. But does this work with large tab...Thanks for this. But does this work with large tables?<BR/>Averagecoder - have you tried Import/Export as a solution to copying tables? Unfortunately, this does not work with tables with 1000s of rows.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-74845082997046422052009-01-16T07:49:00.000-08:002009-01-16T07:49:00.000-08:00your a retard lmaoyour a retard lmaoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-17899887957274856732009-01-13T06:33:00.000-08:002009-01-13T06:33:00.000-08:00you're a star!you're a star!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-56838363009235283412008-10-29T00:09:00.000-07:002008-10-29T00:09:00.000-07:00Thanks a lot! Nice blog!Thanks a lot! Nice blog!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-13681695897680199082008-10-24T06:03:00.000-07:002008-10-24T06:03:00.000-07:00thanks for the help :-)thanks for the help :-)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-90803028662901615052008-10-22T09:45:00.000-07:002008-10-22T09:45:00.000-07:00averagecoder: The solution you choose also depends...averagecoder: The solution you choose also depends on the size of your table. Using the scripts 'may' not feasible if your table contains a million rows.Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.com