Share via

3.1.5.134 proc_WriteStreamToSQL

The proc_WriteStreamToSQL stored procedure creates a new stream binary piece for a document.

 PROCEDURE dbo.proc_WriteStreamToSQL (
     @SiteId       uniqueidentifier,
     @DocId        uniqueidentifier,
     @Partition    tinyint,
     @BSN          bigint,
     @Size         int,
     @Type         tinyint,
     @Expiration   datetime,
     @Data0 varbinary(max), @Length0 bigint, @Offset0 bigint,
     @Data1 varbinary(max), @Length1 bigint, @Offset1 bigint,
     @Data2 varbinary(max), @Length2 bigint, @Offset2 bigint,
     @Data3 varbinary(max), @Length3 bigint, @Offset3 bigint,
     @Data4 varbinary(max), @Length4 bigint, @Offset4 bigint,
     @Data5 varbinary(max), @Length5 bigint, @Offset5 bigint,
     @Data6 varbinary(max), @Length6 bigint, @Offset6 bigint,
     @Data7 varbinary(max), @Length7 bigint, @Offset7 bigint,
     @Data8 varbinary(max), @Length8 bigint, @Offset8 bigint,
     @Data9 varbinary(max), @Length9 bigint, @Offset9 bigint,
     @Data10 varbinary(max), @Length10 bigint, @Offset10 bigint,
     @Data11 varbinary(max), @Length11 bigint, @Offset11 bigint,
     @Data12 varbinary(max), @Length12 bigint, @Offset12 bigint,
     @Data13 varbinary(max), @Length13 bigint, @Offset13 bigint,
     @Data14 varbinary(max), @Length14 bigint, @Offset14 bigint,
     @Data15 varbinary(max), @Length15 bigint, @Offset15 bigint,
     @Data16 varbinary(max), @Length16 bigint, @Offset16 bigint,
     @Data17 varbinary(max), @Length17 bigint, @Offset17 bigint,
     @Data18 varbinary(max), @Length18 bigint, @Offset18 bigint,
     @Data19 varbinary(max), @Length19 bigint, @Offset19 bigint,
     @Data20 varbinary(max), @Length20 bigint, @Offset20 bigint,
     @Data21 varbinary(max), @Length21 bigint, @Offset21 bigint,
     @Data22 varbinary(max), @Length22 bigint, @Offset22 bigint,
     @Data23 varbinary(max), @Length23 bigint, @Offset23 bigint,
     @Data24 varbinary(max), @Length24 bigint, @Offset24 bigint,
     @Data25 varbinary(max), @Length25 bigint, @Offset25 bigint,
     @Data26 varbinary(max), @Length26 bigint, @Offset26 bigint,
     @Data27 varbinary(max), @Length27 bigint, @Offset27 bigint,
     @Data28 varbinary(max), @Length28 bigint, @Offset28 bigint,
     @Data29 varbinary(max), @Length29 bigint, @Offset29 bigint,
     @Data30 varbinary(max), @Length30 bigint, @Offset30 bigint,
     @Data31 varbinary(max), @Length31 bigint, @Offset31 bigint,
     @Data32 varbinary(max), @Length32 bigint, @Offset32 bigint,
     @Data33 varbinary(max), @Length33 bigint, @Offset33 bigint,
     @Data34 varbinary(max), @Length34 bigint, @Offset34 bigint,
     @Data35 varbinary(max), @Length35 bigint, @Offset35 bigint,
     @Data36 varbinary(max), @Length36 bigint, @Offset36 bigint,
     @Data37 varbinary(max), @Length37 bigint, @Offset37 bigint,
     @Data38 varbinary(max), @Length38 bigint, @Offset38 bigint,
     @Data39 varbinary(max), @Length39 bigint, @Offset39 bigint,
     @Data40 varbinary(max), @Length40 bigint, @Offset40 bigint,
     @Data41 varbinary(max), @Length41 bigint, @Offset41 bigint,
     @Data42 varbinary(max), @Length42 bigint, @Offset42 bigint,
     @Data43 varbinary(max), @Length43 bigint, @Offset43 bigint,
     @Data44 varbinary(max), @Length44 bigint, @Offset44 bigint,
     @Data45 varbinary(max), @Length45 bigint, @Offset45 bigint,
     @Data46 varbinary(max), @Length46 bigint, @Offset46 bigint,
     @Data47 varbinary(max), @Length47 bigint, @Offset47 bigint,
     @Data48 varbinary(max), @Length48 bigint, @Offset48 bigint,
     @Data49 varbinary(max), @Length49 bigint, @Offset49 bigint,
     @Data50 varbinary(max), @Length50 bigint, @Offset50 bigint,
     @Data51 varbinary(max), @Length51 bigint, @Offset51 bigint,
     @Data52 varbinary(max), @Length52 bigint, @Offset52 bigint,
     @Data53 varbinary(max), @Length53 bigint, @Offset53 bigint,
     @Data54 varbinary(max), @Length54 bigint, @Offset54 bigint,
     @Data55 varbinary(max), @Length55 bigint, @Offset55 bigint,
     @Data56 varbinary(max), @Length56 bigint, @Offset56 bigint,
     @Data57 varbinary(max), @Length57 bigint, @Offset57 bigint,
     @Data58 varbinary(max), @Length58 bigint, @Offset58 bigint,
     @Data59 varbinary(max), @Length59 bigint, @Offset59 bigint,
     @Data60 varbinary(max), @Length60 bigint, @Offset60 bigint,
     @Data61 varbinary(max), @Length61 bigint, @Offset61 bigint,
     @Data62 varbinary(max), @Length62 bigint, @Offset62 bigint,
     @Data63 varbinary(max), @Length63 bigint, @Offset63 bigint
 )

@SiteId: The site collection identifier of the site collection containing the document.

@DocId: The document identifier of the document.

@Partition: The stream partition that the new stream binary piece belongs to.

@BSN: The BLOB sequence number of the new stream binary piece.

@Size: The size, in bytes, of the new stream binary piece.

@Type: The stream type of the new stream binary piece.

@Expiration: The timestamp in UTC format of the stream binary piece. If the stream binary piece does not have an expiration, this parameter MUST be NULL.

@Data[0-63]: A piece of the binary data for the stream binary piece. See definition for details of format.

@Length[0-63]: This value MUST be the length of the corresponding @Data parameter, in bytes.

@Offset[0-63]: The offset in the stream binary piece where the corresponding @Data belongs. This value MUST be greater than or equal to zero, and this value plus the corresponding @Length parameter MUST be less than or equal to the total size of the new stream binary piece.

Return Values: The proc_WriteStreamToSQL stored procedure returns an integer return code which MUST be listed in the following table.

Value

Description

0

Successful execution.

29

Unexpected error.

80

A stream binary piece with the same BLOB sequence number or stream identifier already exists.

The proc_WriteStreamToSQL stored procedure MUST NOT return a result set.