Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    3

    Unanswered: SQl stored procedure

    hi,
    I am new to SQL Server .I need to extract image data type from SQL Server using TSQL in stored procedure and store them in a temp directory name on my hard disk .
    my table name is
    test
    id varchar(255)
    bmp image

    i want to store this image after extracting in a directory....

    Is there any way i can do it?.I tried with sp_Oacreate ()with ADODB ,but i am not getting it..So guys could u help me out in this..

    bye

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to books online for READTEXT/WRITETEXT/UPDATETEXT topics which covers dealing with text/image datatypes.

    Also refer to this SQL City link for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jun 2003
    Posts
    3

    Thanks satya

    hi,
    actually in this i need to download a big file from the table and write it in a file on my disk..could u suggest anything in this ..
    bye
    montu


    Originally posted by Satya
    Refer to books online for READTEXT/WRITETEXT/UPDATETEXT topics which covers dealing with text/image datatypes.

    Also refer to this SQL City link for more information.

  4. #4
    Join Date
    Jun 2003
    Posts
    3

    Thanks satya

    hi,
    actually in this i need to download a big file from the table and write it in a file on my disk..could u suggest anything in this ..
    bye
    montu


    Originally posted by Satya
    Refer to books online for READTEXT/WRITETEXT/UPDATETEXT topics which covers dealing with text/image datatypes.

    Also refer to this SQL City link for more information.

Posting Permissions

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