x

How filestream in used in Uploading a text or image file

Can anybody please sugges me, I need to upload a file from my application and want it to store in a filegroup of Filestream and want to keep a reference for that in any column of my table, how can i do that
more ▼

asked Jun 28 '12 at 04:45 AM in Default

ritesh.grover gravatar image

ritesh.grover
0 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Once you have everything configured, then you access it normally using the T-SQL as the field stored on file stream is mostly varbinary(max). SQL Server than takes care about everything under the hood.

Second option is to access the file stream using managed API.

You can check examples on SimpleTalk An Introduction to SQL Server FileStream, or MSDN [Getting Started with FILESTREAM Storage][2].

[2]: http://msdn.microsoft.com/en-us/library/bb933995(v=sql.105).aspx
more ▼

answered Jun 28 '12 at 05:14 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.2k 8 11 21

Thanks Pavel for such a quick Response
Jun 29 '12 at 11:32 AM ritesh.grover
If this helped you, you can accept the answer so everybody knows that this issue was solved and it helped to solve your problem.
Jun 29 '12 at 11:45 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x9
x5
x5

asked: Jun 28 '12 at 04:45 AM

Seen: 780 times

Last Updated: Jun 29 '12 at 11:45 AM