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

    Unanswered: Insert image sql statement

    hi all,

    This might seem to be a simple question. I have created a table which stores images (data type image).

    My problem is I don't know the exact the sql statement to insert an image (Insert into table ViewImage values (my problem is the value here). I've found out about readtext and writetext..do I use these functions? and how do I use them?

    I can't use the storing URL way..cuz..my supervisor doesn't allow it!

    Thanks!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Same as refer to books online READTEXT/WRITETEXT/UPDATETEXT topics which has code examples.

    Refer to SQLMAG 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
    2
    Hey Satya,

    THanks a lot!

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    As referred keep in touch with books online as a first hand information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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