This is a simple routine that shows how to combine several binary values into a single image value. This is similar to string concatenation & this example just adds the bytes together as a stream. [ All Languages » SQL Server »  BLOB (Text-Image)] Total Hit ( 2340) Rate this article:     Poor     Excellent   Submit Your Question/Comment about this article Rating

Click here to copy the following block /* To concatenate several binary values into one image field: */ create table #Bin ( SegmentID int IDENTITY ( 1 , 1 ) , Segment varbinary(2) ) insert #Bin values (0x11) insert #Bin values (0x22) select * from #Bin go declare @imageptr varbinary(16), @segmentid int, @segment varbinary(16) create table #AllBin ( Segments image null ) -- Get valid pointer first insert #AllBin values ( 0x0 ) select @imageptr = TEXTPTR( Segments ) from #AllBin -- Set data to null update #AllBin set Segments = null select @segmentid = -1 while(1=1) begin   select @segmentid = min(segmentid)   from #Bin   where segmentid > @segmentid   if @segmentid is null break   select @segment = segment from #Bin where segmentid = @segmentid   updatetext #AllBin.Segments @imageptr null 0 @segment end select * from #AllBin go drop table #Bin drop table #AllBin go

Related Article(s)

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)
	Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )