Database

SELECT * FROM MyTable
WHERE Col_Name LIKE '%~%' OR Col_Description LIKE '%~%'
    OR Col_Name LIKE '%`%' OR Col_Description LIKE '%`%'
    OR Col_Name LIKE '%!%' OR Col_Description LIKE '%!%'
    OR Col_Name LIKE '%@%' OR Col_Description LIKE '%@%'
    ...

SELECT * FROM MyOtherTable
WHERE OtherCol_Name LIKE '%~%' OR OtherCol_Description LIKE '%~%'
    OR OtherCol_Name LIKE '%`%' OR OtherCol_Description LIKE '%`%'
    OR OtherCol_Name LIKE '%!%' OR OtherCol_Description LIKE '%!%'
    OR OtherCol_Name LIKE '%@%' OR OtherCol_Description LIKE '%@%'
    ...

DECLARE @idoc int
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @TagXml

SELECT *
into [#Tag]
FROM  OPENXML (@idoc, '/Tag',2)	-- be very careful this is case sensitive
WITH ( ID int, Descr varchar(128), TypeID int, Note varchar(256), Static varchar(7), objID int )

-- get the list of ids from the edge table
SELECT convert(int, convert(varchar(10), [Text]) ) AS [ID]
into [#ObjList]
FROM  OPENXML (@idoc, '/Tag/objID',2)	-- be very careful this is case sensitive
WHERE [Text] is not null

DECLARE @idoc int
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @TagXml 

-- get the list of ids from the edge table
SELECT convert(int, convert(varchar(10), [Text]) ) AS [ID]
into [#ObjList]
FROM  OPENXML (@idoc, '/Tag/objID',2)	-- be very careful this is case sensitive
WHERE [Text] is not null</pre>

FROM  OPENXML (@idoc, '/Tag/objID',2)	-- be very careful this is case sensitive
WHERE [Text] is not null&lt;/pre&gt;</pre>

'<Tag>  <ID>0</ID>  <Descr>new_taggy</Descr>  <TypeID>1</TypeID>  <Note />  <Static>true</Static></Tag>'

2 Use the element-centric mapping.
Can be combined with XML_ATTRIBUTES; in which case, attribute-centric mapping is applied first, and then element-centric mapping is applied for all columns not yet dealt with.