.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

send first table data to another table

Posted By: kamlesh     Posted Date: February 25, 2011    Points:2   Category :Sql Server
hi

i want to send first table data to another table in sql server 2005

for ex: i have MailMaster Table and MailMasterNew Table and i want to sent MailMasterNew data to MailMaster. means when i am importing some mail so it will save into MailMasterNew table and when i want access that data so i use MailMaster table so hw it is possible.

Please help me

Thanks
Kamlesh


Responses
Author: Manas Patnaik             
Posted Date: February 25, 2011     Points: 5   

I am not seeing any issues here use simple SQl insert queries

INSERT INTO MailMaster SELECT * FROM MailMasterNew

then you can Delete the MailMasterNew data.


Manas Patnaik
http://manaspatnaik.com/blog
Author: Deep Gautam             
Posted Date: February 25, 2011     Points: 5   

select * into MailMasterNew from MailMaster.


Make sure drop the table MailMasterNew before runnig this query.


Deep Gautam
Happy Coidnmg

Author: ANWER JAMAL             
Posted Date: September 17, 2011     Points: 20   

Hi kamlesh use this query
it works fine,

SELECT * FROM MAILMASTER
INSERT INTO MAILMASTERNEW



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend