|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
select for output columns from table and local file as image.I would like to use a select statement that selects various columns from a
database table but also contains as the output of the select statement an image datatype which has been set to the value of a bitmap btained from a local file at location c:// How would I do that? Thank you. -hazz Hi
To display an image you will need to use a machanism on the client and this is not part of the SQL Server tools. Reading this may help http://www.aspfaq.com/show.asp?id=2149 John Show quote "hazz" <h***@sonic.net> wrote in message news:uC95aRsLGHA.2696@TK2MSFTNGP14.phx.gbl... >I would like to use a select statement that selects various columns from a >database table but also contains as the output of the select statement an >image datatype which has been set to the value of a bitmap btained from a >local file at location c:// > How would I do that? > > Thank you. > -hazz > Thank you for the idea John.
Show quote "John Bell" <jbellnewspo***@hotmail.com> wrote in message news:%23JsJfLwLGHA.3856@TK2MSFTNGP12.phx.gbl... > Hi > > To display an image you will need to use a machanism on the client and > this is not part of the SQL Server tools. > > Reading this may help http://www.aspfaq.com/show.asp?id=2149 > > John > > "hazz" <h***@sonic.net> wrote in message > news:uC95aRsLGHA.2696@TK2MSFTNGP14.phx.gbl... >>I would like to use a select statement that selects various columns from a >>database table but also contains as the output of the select statement an >>image datatype which has been set to the value of a bitmap btained from a >>local file at location c:// >> How would I do that? >> >> Thank you. >> -hazz >> > > |
|||||||||||||||||||||||