This is a discussion on "Storing an image into Sql Server Database " within the SQL Server forums, part of the Microsoft SQL Server category; --> Is there any way of storing an image file into a specific Table . It would be of great ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| (santosh_stb@indiatimes.com) writes: > Is there any way of storing an image file into a specific Table . > It would be of great help for me if i come to know something about it. You can use the image datatype. You can also opt to store the image in the file system and store only the path in the database as Madhivanan suggested. This latter is simpler to implement, in the short-term at least, but is less reliable since you have poorer transaction scope, the file can more easily disappear. Thus using image is more robust, but admittedly it takes more code to come there. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |
| Thread Tools | |
| Display Modes | |
|
|