RE: Selecting data stored using FileStream in SQl Server

2012-05-13 Thread Peter Maddin
immediately. From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stuart Kinnear Sent: Sunday, 13 May 2012 10:15 AM To: ozDotNet Subject: Re: Selecting data stored using FileStream in SQl Server Hi Peter, Further to the idea of using BCP in lieu of C

Re: Selecting data stored using FileStream in SQl Server

2012-05-12 Thread Stuart Kinnear
You can get stuff in very easily using the plethora of examples, however using T-SQL to get the record out is not possible, perhaps because of the need to isolate the field value and deal with it separately. If you were to create a clr function using the info available for c# code then you would

RE: Selecting data stored using FileStream in SQl Server

2012-05-12 Thread Greg Low (GregLow.com)
Subject: Re: Selecting data stored using FileStream in SQl Server You can get stuff in very easily using the plethora of examples, however using T-SQL to get the record out is not possible, perhaps because of the need to isolate the field value and deal with it separately. If you were to create a clr

Re: Selecting data stored using FileStream in SQl Server

2012-05-12 Thread Stuart Kinnear
Hi Peter, Further to the idea of using BCP in lieu of C# code, I tried a format file: perhaps there is something wrong in the mapping. (see http://msdn.microsoft.com/en-us/library/ff719290(v=sql.105).aspx) ?xml version=1.0? BCPFORMAT xmlns=