June 18, 2012 at 11:08 am
Hello,
I have a database (that I inherited) that has two image tables - one table is setup to use an image column and the other uses a text column.
For the first time someone wants an image from the table that uses the text column... Is there anyway to recover the information? The data appears to be intact (just not as image), but I cannot get the data to convert when I try to write the bmp file with a VB application.
Any guidence would be appreciated!
Thanks
-Steve
June 18, 2012 at 1:35 pm
Pretty sparse on details here. What does the VB code look like? What does the sql you are using look like?
You will get lot more help if you can post some details. DDL, sample data.
I know you inherited these but once you get this resolved you should consider changing the datatype to varbinary(max) instead because both the text and image datatypes are deprecated. http://msdn.microsoft.com/en-us/library/ms187993.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply