CREATE OR REPLACE Function Blob_To_Varchar (Blob_In In Blob) Return clobIs
V_Varchar Varchar2(32767);
V_Varchar1 Varchar2(32767);
V_Start Pls_Integer := 1;
V_Buffer Pls_Integer := 4000;
Begin
If Dbms_Lob.Getlength(Blob_In) Is Null Then
Return '';
End If;
V_Varchar1 := '';
For I In 1..Ceil(Dbms_Lob.Getlength(Blob_In) / V_Buffer) Loop
V_Varchar := Utl_Raw.Cast_To_Varchar2(Dbms_Lob.Substr(Blob_In, V_Buffer, V_Start));
V_Varchar1 := V_Varchar1 || V_Varchar;
V_Start := V_Start + V_Buffer;
End Loop;
Return V_Varchar1;
End Blob_To_Varchar;
帮忙转换成sqlserver 版本 ，谢谢。。。。。。