Database Doubt

[rnjnagu]

INSERT INTO [ET_SolutionText]
([SolnTextKey]
,[SolnTextValue]
,[SolnTextTitle])
VALUES
('OM_SUP'
,'XML DATA'
,'OM Supplier Content')
GO


In Above Query, SolnTextValue is XML field. How i can format XML data in Values using insert query in SQL server 2008??

[Shaggy Hiker]

XML is just text, so it doesn't really need anything special to go into any text field that is large enough to hold it.