SQLServer2008把Image类型里的html文本查询取出来

SQLServer2008把Image类型里的html文本查询取出来

-- select CONVERT(varchar(max), CONVERT(varbinary(MAX), imgField1)), * from Table1

update t set content_html=CONVERT(varchar(max), CONVERT(varbinary(MAX), imgField1)) from table1 as t

select * from table1 as t