Solved

Creating image table in MS SQL server 2005

Posted on 2009-05-07
2
159 Views
Last Modified: 2012-05-06

What I have:
A network directory with image files (smal jpgs) stored in multiple sub-directories under the root.
What I need:
Code to create a table to store the image files in the table.
Table should have 4 columns:
ID ( a unique identifier)
Image File
Image File Name
UPC (This is just the image file name minus the .jpg extension)

Code to insert all the images into the table, insert the filenames, strip .jpg from filename for insert into UPC column.

Thanks in advance.
0
Comment
Question by:swissfarms
2 Comments
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24332843
0
 

Author Closing Comment

by:swissfarms
ID: 31579025
Thanks RiteshShah!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now