Handling Large Object (LOB) Parameters in the CLR

  • 發行項

Use SqlBytes and SqlChars to pass large object (LOB) binary type (varbinary(max)) and LOB character type (nvarchar(max)) parameters, respectively. These types allow streaming the LOB values from the database to the common language runtime (CLR) routine, instead of copying the entire value into managed space. SqlBinary and SqlString should be used only for small binary and character string values.

For an example of how to handle large objects, see the 大型物件 (LOB) 處理 sample.

請參閱

其他資源

SQL Server Data Types in the .NET Framework

說明及資訊

取得 SQL Server 2005 協助