How To Insert Data From A Select

0Comments

TODO:

Have you ever wanted to insert data by selecting values from a table?

SOLUTION:

Consider we have a table called XMLData, and it has a column called Id, Type, RawData

INSERT INTO XMLData (RawType, RawData)
SELECT 'Client', RawData FROM XMLData WHERE RawType = 'Customer'

NOTES:

The example above will copy records flagged as RawType = 'Customer', and insert them as new records, changing the RawType to 'Client'

How To Populate A Table With ISO 3166-1 Country DataTODO: Did you ever need a reference table of ISO country data? Is so, create a tabl...How To Populate A Table With US State DataTODO: Have you ever wanted to have a table of US states and not have to type them in. If...How To Convert A SqlDataReader To A DataTable Using C#TODO: Have you ever wanted to convert a SqlDataReader to a DataTable in C#? SOLUTION: &nb...

	Subscribe		Contact
Archive		Twitter

Thank you