0
In short, the SQL database column has to be defined as either an image column or a binary column (SQL2k) In earlier versions, 6.5 & 7, they should have been defined as a BLOB (Binary Large Object). A more precise answer can be given if you supply additional information such as DB version, programming langauge used.
**
As explained here you can store images within SQL server however I would not recommend this.
In doing so you will bloat the database dramatically, and the reconstitution of the images when recalled from the database is a big performance hit.
I would recommend storing the images within the file system (saved to your hard drive as normal) and linking the images to a database record by defining a column that hold the path and file name to the image.
In doing so your database overhead is simply that field and not the entire image.
What else can I help you with?
Where can you see Chinese Brush Paintings?
you mostly can find at in china or in Chinese store that sales pictures
What is the best way to store printed pictures to ensure their longevity and preservation?
The best way to store printed pictures for longevity and preservation is to keep them in acid-free photo albums or archival-quality boxes, away from light, heat, and humidity. It is also recommended to handle them with clean hands and avoid touching the printed surface to prevent damage.
What is the best way to store old pictures to ensure their preservation and longevity?
The best way to store old pictures for preservation and longevity is to keep them in a cool, dry, and dark environment, away from direct sunlight and extreme temperatures. Store them in acid-free photo albums or archival-quality boxes to protect them from damage. Additionally, handling them with clean hands and using cotton gloves can help prevent oils and dirt from transferring onto the photos.
What are some unique features of the camera keychain with pictures?
The camera keychain with pictures is a compact device that allows you to take photos and store them on a keychain. It is unique because of its small size, portability, and convenience. Additionally, it can be a fun and creative way to capture memories on the go.
How can I preserve old pictures for future generations?
To preserve old pictures for future generations, store them in a cool, dry place away from sunlight and humidity. Use acid-free materials for framing and storage, and consider digitizing them for easy access and backup. Handle them with clean hands and avoid using tape or adhesive on the photos. Regularly inspect and maintain the condition of the pictures to ensure their longevity.
Give database for medical store system in SQL server 2005?
database for medical shop in sql
Is SQL a Database?
SQL is not Database, it is a Language used to communicate with Database...
What database does facebook uses?
facebook uses "NO SQL" database "NO SQL" name is derived from first letters of NOT ONLY SQL
What is sql database?
An SQL database is one that implements the use of Structured Query Language to manage data stored in the database. SQL is the most used way of communicating with databases.
What are some unique features of SQL web hosting?
SQL webhosting is used for websites that store and display data from a database. SQL databases can be hosted on both Windows and Linux/UNIX operating systems.
Is SQL An application to manage Data in a database?
SQL is a language broad term to define a type of database. More specific ones are My SQL (open source) and MicroSoft SQL
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
Which SQL database products do not run on Linux?
The following is a list of SQL database systems that do not currently have a Linux version:4th DimensionMicrosoft SQL ServerOracle RdbR:BaseScimoreDB
Difference between SQL Exception class and SQL Warning class?
sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.
Good topics of mini project on database using sql?
sql
What is the core of sql server's processing sql statements?
Database Engine
Types of databases in sql server 2005?
Types of Database in sql server 2005:- 1.Master Database 2.Tempdb Database 3.Model Database 4.MSDB Database 5.Resource Database
