This entry was posted on Monday, May 23rd, 2005 at 11:39 am and is filed under Uncategorized, Tech data. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
Insert a record:
“INSERT INTO Person (field1, filed2…) VALUES (value1, value2,…)”
Insert using a select statement:
INSERT INTO NGLinkCon
(ConID)
SELECT AutoID AS ConID
FROM COntacts
WHERE (firstname = `roland`)
INSERT INTO eshot_Extract.dbo.Contacts (Firstname, Lastname, email, Company) SELECT Contacts.Firstname, Contacts.Lastname, Contacts.email, Contacts.Company FROM eshot_forfront2.dbo.Contacts INNER JOIN eshot_forfront2.dbo.NGLinkCon ON Contacts.AutoID = NGLinkCon.ConID WHERE NGLinkCon.NGID = 18