Storing text file containing XML in SQL Server db

[SpiderBear]

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.

[mendhak]

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

[Edneeis]

You could also use text or ntext.

[mendhak]

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?

[Edneeis]

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).

[mendhak]

Pfft... MS buzzwords.