Building a cache table, database helpers

I have a few tables of possible combinations for item names, like base name, prefixes and suffixes - however it isnt very good to search directly in these tables as I have to generate the combinations every time, to fix it I created a Cache table where I pl开发者_运维百科an to run some cron job to fill it up. I have to create a script that populates the cache and it just doesnt seem smart to build the SQL procedurally with string concatenations.

Is there anyway I can insert a SQL result set into a table? Without creating the actualy INSERT statement manually.

Thanks.

---

I don't know if there's any way to insert records with doing an insert, but you can insert a result set in a couple of different ways:

The first method is an INSERT INTO SELECT:

INSERT INTO Table1 (Col1, Col2, Col3)
    SELECT Col1, Col2, Col3
    FROM Tabl2

The second is a SELECT INTO:

SELECT Col1, Col2, Col3
INTO Table2
FROM Table1

I don't know if that helps to answer your question, but hopefully it will put you on the right path.

---

You can use my SqlCeBulkCopy library, takes DataReader, DataTable or any List object as parameter... http://sqlcebulkcopy.codeplex.com