question

StanleyBarnett avatar image
StanleyBarnett asked

Joins on a FileTable?

Hi, Using SQLServer 2012, how do I join a different table to a fixed FileTable? Being fixed, it cannot be altered it in any way. So if I cannot add columns for join or other usage, then what good is the FileTable setup and why would anyone use it? What are some use case scenarios... To better explain, I have a product table and I keep its images in a FileTable table where its data is stored "out of the database" and in the file system. How are these joined? Thanks, Stanley
sqlfilegroupfilestream2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.