Storing text file containing XML in SQL Server db

Hi all,

I am trying to store the contents of a text file into a field in a SQL Server database. I am not sure what sort of data type to use in the database. I tried using an image field but I couldn't seem to get the text out again (not really sure it went in in the first place.)

Thanks for any help in advance.

Cheers
SpiderBear.

You could use a BLOB to store the entire file as it is, or to store the contents, make the field VARCHAR(somevalue).

You could also use text or ntext.

I've heard of SQL 2000's support for XML, but what really is it? Have they modified their T-SQL to allow for this or what?

There is a FOR XML set of keywords in the T-SQL that will extract data as XML but it doesn't store it as such (as far as I know).

Pfft... MS buzzwords. :lol: