Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alxtech
Yak Posting Veteran
66 Posts |
Posted - 2007-02-23 : 09:43:38
|
| additional to data, what other type of information can be store in sql databases, i need to store pictures and mp3's that can be done, if not do you know what storage can be used for this purpose? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-23 : 10:11:32
|
| Although it is possible, it is not advisable to store BLOB (pictures, mp3 etc) data in the database. Instead you can store these files on the local file system and store only the paths inside the database.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
alxtech
Yak Posting Veteran
66 Posts |
Posted - 2007-02-23 : 10:14:52
|
| mp3 files have metadata associated with them such as artist name, album, song title, duration etc.....Do you know a way to retrieve all this information, i am creating a juke box and the search will use this criteria to look for songs. |
 |
|
|
|
|
|