Import a URI to a sql field

Question

I storing html to a text field. The html is a fully formed webpage and is stored on my server. I'm frequently updating this field. Currently, after updating the content (using Dreamweaver) and then validating that layout is correct in my browser, I'm manually pasting the HTML to a SSMS query. It'd be easier execute:

update template set myhtmlBody = myFileName

where myfileName resolves either to an http address or an absolute path on the SQLServer's box.

possible?

thx

Answer 1

Yes, looks possible but difficult.