Write (Database Engine)

Article
11/18/2022

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

Write writes out a binary representation of SqlHierarchyId to the passed-in BinaryWriter. Write cannot be called by using Transact-SQL. Use CAST or CONVERT instead.

Syntax

void Write( BinaryWriter w )

Note

To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

Arguments

w
A BinaryWriter object to which the binary representation of this hierarchyid node will be written out.

Return Types

CLR return type:void

Remarks

Write is used internally by SQL Server when it is necessary, such as when loading data from a hierarchyid column. Write is also called internally when a conversion is done between hierarchyid and varbinary.

Examples

MemoryStream stream = new MemoryStream();  
BinaryWriter bw = new BinaryWriter(stream);  
hid.Write(bw);  
byte[] encoding = stream.ToArray();