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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-12 : 11:19:11
|
| Selim Atmaca writes "I have been searching about How to store an mp3 file or a music file in SQL Server for a while. However I still have no clue. Can you send me some articles or tutorials or explain hoow it is done?Thank you very muchSELIM" |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-07-12 : 11:25:46
|
| I would REALLY just store a path to the file, rather than the file itself.Help us help YOU!Read this blog entry for more details: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected) |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-12 : 11:26:05
|
| You would have to store it in an image datatype.It's yusually better to store it as a file and hold the filepath in the database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-07-12 : 12:42:14
|
| Here's a 'pros and cons' article...http://www.aspfaq.com/show.asp?id=2149Ryan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-13 : 01:16:42
|
| http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How do I store an mp3 file or a music file in SQL Server