SELECT s.name AS SchemaName, o.name AS ObjectName, CAST((SELECT m.definition FOR XML PATH('')) as XML) ObjectDefinition, o.typedesc FROM sys.sqlmodules m INNER JOIN sys.objects o ON m.objectid o.objectid INNER JOIN sys. In order to have those characters appear as data (instead of for their special meaning) they can be represented by entities ( < for is supposed to be data or the start tag for a hello element. By first creating a XML document with the FOR XML statement, and then casting it as XML in the result set, we obtain what we were looking for. So in order to escape something & something use: something \& something In the case of apostrophe and quotes simply using a backslash works too., &, " and ' all have special meanings in XML (such as "start of entity" or "attribute value delimiter"). Well in Android XML simply adding the Predeclared entities didn't work in my case, needed to add a backslash before it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |