Insert SQL Query into SQL Table

INSERT
TESTDB_TABLE
(WooTargetField, BTargetField, BlahTargetField)
Select A as 'WOO', B, Z as 'BLAH'
   FROM TESTDB_TABLE
WHERE A = 'ABCDEFGHIJK..£$'

If you wish to update a single table field your select cannot have multiple fields - it would have to return a single value or concatentate the several source fields into a single expression

UPDATE target
SET target.Field = (SELECT SingleValue FROM Source)

I think you both misunderstand my question, sorry,

I actually want to insert/update sql query text into a sql field, not the value the query returns but the actual sql query string. I'm building a reporting tool for myself and basically i want to to save generated sql statements into a table for future use, but some special characters in the sql query string cause the insert/update to fail.


I.E this will fail due to single quotes:  

SELECT 'SELECT VPXV_VMS.NAME AS VMNAME, 
       VPXV_SNAPSHOT.SNAPSHOT_NAME 
FROM VPXV_SNAPSHOT,VPXV_VMS 
WHERE VPXV_VMS.VMID = VPXV_SNAPSHOT.VM_ID 
 AND(VPXV_SNAPSHOT.POWER_STATE = 'dw')' as SQLQuery

Select allOpen in new window

Msg 102, Level 15, State 1, Line 6
Incorrect syntax near ')'.

Select allOpen in new window

Replace every embedded single quote with 2 single quotes:

UPDATE TESTDB_TABLE set SQLquery = 'Select A as ''WOO'', B, Z as ''BLAH''
   FROM TESTDB_TABLE
WHERE A = ''ABCDEFGHIJK..£$'''

Note that the ending ''' is 3 single quotes - 2 to create the quote after the $ in your embedded string, and one to end the SQLquery string.