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.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
Where can you see Chinese Brush Paintings?
you mostly can find at in china or in Chinese store that sales pictures
What is the collective name of pictures?
Some collective nouns for pictures are: a collection of pictures an album of pictures
Can you show me some pictures?
what do you need to see pictures of?
Can you show me pictures of an anus turned inside out?
No, such pictures are not allowed on answers.com.
Some pictures of Cleopatra?
To get pictures of Cleopatra just type "Cleopatra/pictures" in your web browser and you'll come up with many web sites with pictures of her. But be warned, no one knows exactly what she looked like and many of her pictures are artist renditions of what they thought she looked like.
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 is a query used for on a database?
A query is used to retrieve specific information or data from a database based on specific criteria. It allows users to search, filter, and retrieve data that meets their requirements. Queries can also be used to update or modify existing data in the database.
What database does facebook uses?
facebook uses "NO SQL" database "NO SQL" name is derived from first letters of NOT ONLY SQL
Is SQL a database or language?
SQL is a language used to communicate with databases. It stands for Structured Query Language. It is used to perform tasks such as querying data, updating data, creating databases, and managing databases.
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
What are dbms languages?
DBMS languages are specialized programming languages used to interact with databases. Common DBMS languages include SQL (Structured Query Language) for querying and manipulating data, and PL/SQL (Procedural Language/SQL) for developing procedures and functions within a database system. These languages are designed to facilitate communication with the database management system and perform various operations on the data stored in the database.
Which SQL statement is used to update data in a database?
The SQL statement used to update data in a database is the "UPDATE" statement. It allows you to modify existing records in a table by specifying the column and value you want to update based on certain conditions. Additionally, you can use the "SET" keyword to assign new values to specific columns in the table.
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
