Solved

Creating image table in MS SQL server 2005

Posted on 2009-05-07
2
161 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

785 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