Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Select and insert...

Author  Topic 

jafrywilson
Constraint Violating Yak Guru

379 Posts

Posted - 2010-10-13 : 06:48:07
Hi..
How to insert values to a table that are present in another table...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-13 : 06:51:52
Look up Insert in SQL's Books Online (the help file). You're looking for the INSERT ... SELECT form of the statement.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

jafrywilson
Constraint Violating Yak Guru

379 Posts

Posted - 2010-10-13 : 06:54:31
Thank you for your reply .can you suggest some books for me..
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-13 : 09:11:31
Books for what?

Start with the free resource that would have been installed with SQL Server - Books Online. in management studio, press F1 (or Start-Programs->Microsoft SQL Server->Documentation and Tutorials-> Books Online)

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -