can to hold a pdf in sql field ? (i.e like bmp as binary)

Hi,
I understand you can hold and image in a sql server field as a binary file.
Can this same process be used to hold an actuall PDF file in a field ? (i.e
as opposed to a link).
note: i would like to display the pdf doc via and asp page.
Thanks for any advice
ScottIt is binary data, so you can hold anything you like in the column. If you don't have a PDF
displayer that can display based on data in a table, you would have to materialize the data to a
file and then use that file in your pdf displayer.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"scott" <nospam@.yahoo.com> wrote in message news:%2375LjvhsFHA.3180@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I understand you can hold and image in a sql server field as a binary file. Can this same process
> be used to hold an actuall PDF file in a field ? (i.e as opposed to a link).
> note: i would like to display the pdf doc via and asp page.
> Thanks for any advice
> Scott
>|||Hi
A PDF would need to be an image data type. It is in effect is a binary data
type.
You need to write code using Getchunk and Appendchunk.
http://support.microsoft.com/default.aspx?scid=kb;en-us;194975
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"scott" wrote:
> Hi,
> I understand you can hold and image in a sql server field as a binary file.
> Can this same process be used to hold an actuall PDF file in a field ? (i.e
> as opposed to a link).
> note: i would like to display the pdf doc via and asp page.
> Thanks for any advice
> Scott
>
>|||thanks
scott