SQLTeam.com | Weblogs | Forums

Oracle to sql migration need to find replacement for dbms_lob.createtemporary() in mssql

Currently I'm working in oracle to sql migration
I could see dbms_lob.createtemporary() in oracle. I want to know what is alternative for this function in sql and need alternative for few statement
sample code
vResult CLOB;
vDelim VARCHAR2(4);
CURSOR curC Is// need alternative
vFld curC %ROWTYPE;
--------------------------
BEGIN

vDelim := NULL;
vDelim := ' ';
vResult := '';
dbms_lob.createtemporary(vResult, TRUE); // need alternative
//from need alternative+++++
FOR vFld IN curC LOOP

  EXIT WHEN curC%NOTFOUND ;

  DBMS_LOB.APPEND(vResult ,vDelim||vFld.depend_link);

END LOOP;
//end need alternative+++++
RETURN vResult;

END;