Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

?
Lv 6

Fetching Data from SQL Data Server!?

I am able to extract the item name, price etc. from the SQL Data for the inventory software. But could not locate the pictures associated with the products to export to MS-Excel or Access. Can someone help. Where can the pictures be?

Thank you.

3 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    That would be a question that can only be answered by looking at the table structures and the data. Based on this and other questions you are asking, I would suggest that you get someone that knows something about SQL to take a look for you.

  • 1 decade ago

    You can insert the picture in the form of binary (blob). while extracting convert it back to the original form from binary.

  • ?
    Lv 4
    4 years ago

    i dont be attentive to what you meant through internet website smart yet you want to apply this question opt for * from product_detail the position rowid <=30 opt for * from product_detail the position rowid>30 and rowid <=60 and so on...

Still have questions? Get your answers by asking now.