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 |
|
irmorteza
Starting Member
8 Posts |
 Posted - 2010-10-20 : 05:27:39
|
| Hi I have myTable as shown below:CREATE TABLE dbo.myTable ( ID UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE, BLOB VARBINARY(MAX) FILESTREAM NULL)Suppose I added a jpeg file to myTable.BLOB. As you know sql save the file in the NTFS file system.Do can I use this saved file like jpeg? Or it’s necessary to read with sqlFileStream and then save as jpeg file in temporary memory to use it?Best. Morteza |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-10-20 : 06:26:22
|
| You will have to read it through the sqlFileStream. It is possible to access it directly from the file system, but the filename is in the format of a GUID and it defies the whole purpose of using filestream. A filestream folder is just the same as a data file...you can have many of them in different locations ever for the same table. It will be not be very effective to figure out which folder each file is in on the fly...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
using FILESTREAM