Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Data Access

Retreiving Images from SQL Server 7.0

I am hoping to avoid writing a DLL to be able to retreive the images stored in a SQL Server 7.0 system. I was hoping that there was something, like a built-in function in SQL Server 2000 that will read the image (xp_readimage?). Does anyone know of something like that? Thanks much!
[282 byte] By [KimScott] at [2007-12-22]
«« MSDN products need extra license?
»» run at task bar
# 1
You will get the binary represenatation by just using the SELECT command. This has to be manifested into a file using e.g. a filestream in .NET. There is no helper function to directly do this.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

JensSuessmeyer at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Data Access...
SQL Server
SQL Server Data Access

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified