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, 2012 at 04:45 AM in Default

avatar image

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.

more ▼

answered Jun 28, 2012 at 05:14 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

Thanks Pavel for such a quick Response

Jun 29, 2012 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, 2012 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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Jun 28, 2012 at 04:45 AM

Seen: 1165 times

Last Updated: Jun 29, 2012 at 11:45 AM

Copyright 2018 Redgate Software. Privacy Policy