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
Once you have everything configured, then you access it normally using the T-SQL as the field stored on file stream is mostly
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].: http://msdn.microsoft.com/en-us/library/bb933995(v=sql.105).aspx
answered Jun 28, 2012 at 05:14 AM