C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




insert query


Posted Date: 14 Apr 2008      Total Responses: 2

Posted By: madhuraj       Member Level: Silver     Points: 2


Hi

Is it possible to select data from one table and insert in to another table based on some conditions.. like this

insert into table1 t1,table t2 values(skills)as('PHP') where t1.ID=t2.ID and t1.NAME=t2.NAME


thanks
madhu




Responses

Author: Nitish Kumar Singh    14 Apr 2008Member Level: GoldRating:     Points: 2
--- You are inserting more than one record at a time then ----you can use then u can use below Query....

insert into nitu (customerid,companyname,contactname)
select customers.customerid,customers.companyname,customers.contactname from Customers,nitu
where nitu.customerid = customers.customerid


Author: Ramdas Singh Baghel    15 Apr 2008Member Level: GoldRating:     Points: 2
Yes It is possible.


Post Reply
You must Sign In to post a response.
Next : insert query
Previous : How to retrive datas in the Textbox : Vb 6.0
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers   BizTalk Adaptors    Web Design

web conferencing

Contact Us    Privacy Policy    Terms Of Use