Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    19

    Unanswered: insert pdf in sql server

    Hello, I need to insert a pdf document in a bbdd sql server.
    What kind of data I use? Image?
    How? Have I used a T-sql procedure for insert and read?
    I am new with sql server
    Thanks a lot.

  2. #2
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up

    hai pilarll

    My understanding of your question is that you want to store PDF files in your SQL Server. The recommented way is to just store the file path in the table. Bcoz, if u r going to store the whole file inside the SQL Server then it will put lot of extra overhead on the server.

    BTW, last week there was a similar post in this forum with title 'Urgent: file management with SQL Server '. Check it out at http://www.dbforums.com/showthread.p...5&goto=newpost


    If ur requirment demands, u to store the file in SQL Server itself then u can use image data type to store the contents of ur file in the data base.

    with regards
    Sudar

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    As sudar has suggested..
    it is recomended to save the file on the disk and store a pointer to the file in the database, but if u decide other wise then this link may be helpfull:
    http://www.sqlteam.com/item.asp?ItemID=986

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •