tag:blogger.com,1999:blog-1457816901612635732.post9150095293354619747..comments2023-06-29T14:59:18.370-07:00Comments on Bob McGowan's Blog: Processing SQL Server FILESTREAM Data, Part 4 - Readin' and Writin'Bob Mchttp://www.blogger.com/profile/10012849048492940436noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1457816901612635732.post-87860497860679493392019-02-13T10:00:51.076-08:002019-02-13T10:00:51.076-08:00Wow i can say that this is another great article a...Wow i can say that this is another great article as expected of this blog.Bookmarked this site.. <a href="https://help-dysk.pl/odzyskiwanie-danych,lodz" rel="nofollow">Odzyskiwanie danych Łódź</a><br />Richard H. Blackhttps://www.blogger.com/profile/14598058396076026111noreply@blogger.comtag:blogger.com,1999:blog-1457816901612635732.post-84817727874878233902015-12-31T14:39:28.439-08:002015-12-31T14:39:28.439-08:00Patrick, my apologies for the delayed reply. I hon...Patrick, my apologies for the delayed reply. I honestly did not see your comments until this very day.<br /><br />There is no reason that the table containing the FILESTREAM cannot also contain another column that is a a FOREIGN KEY into a related table. If you run into any issues with that construct feel free to contact me.<br />Bob Mchttps://www.blogger.com/profile/10012849048492940436noreply@blogger.comtag:blogger.com,1999:blog-1457816901612635732.post-77535724723605212312015-08-10T13:26:16.811-07:002015-08-10T13:26:16.811-07:00Quick question..... Can a Filestream contain a for...Quick question..... Can a Filestream contain a foreign key? Like so:<br /><br />CREATE TABLE [dbo].[AttachmentFileStream](<br /> [attachmentID] [bigint] IDENTITY(1,1) NOT NULL,<br /> [guid] [uniqueidentifier] ROWGUIDCOL UNIQUE NOT NULL DEFAULT (newid()),<br /> [Name] [nvarchar](100) NOT NULL,<br /> [Data] [varbinary](max) FILESTREAM NULL,<br /> [emailID] [bigint] NOT NULL, //Foreign Key<br /> [description] [varchar](max) NULL, //I should delete this because I am not using this column<br /> [filesize] [float] NULL, //I should probably calculate the size everytime and delete this column.<br /> [timestep] [datetime2](7) NULL DEFAULT (sysdatetime()),<br />PRIMARY KEY CLUSTERED......<br /><br />This way all attachments for a single email can be grouped together.<br />Anonymoushttps://www.blogger.com/profile/02913669692302562057noreply@blogger.comtag:blogger.com,1999:blog-1457816901612635732.post-4567705020918713422015-08-10T13:17:36.215-07:002015-08-10T13:17:36.215-07:00Reading, Riting, and Rithmitic..... Spelling was n...Reading, Riting, and Rithmitic..... Spelling was not deemed important. Anonymoushttps://www.blogger.com/profile/02913669692302562057noreply@blogger.com