SQL Server 2005ÖÐдÎļþµÄ·½·¨

--´´½¨Ð´ÎļþµÄ´æ´¢¹ý³Ì
ALTER proc [dbo].[p_movefile]
 @filename varchar(1000),--Òª²Ù×÷µÄÎı¾ÎļþÃû  
 @text varchar(8000),   --ҪдÈëµÄÄÚÈÝ
 @obj int
as  
begin
 declare @err  int,
   @src  varchar(255),
   @desc varchar(255)   
   
 exec @err=sp_oamethod @obj, 'OpenTextFile', @obj  out, @filename,8,1  
 if @err<>0  
  goto lberr  
 exec @err=sp_oamethod   @obj,'WriteLine',null,@text  
 if @err<>0  
  goto lberr  
   
 exec @err=sp_oadestroy @obj  
 return    
lberr:  
 exec sp_oageterrorinfo 0, @src out,@desc out  
 select cast(@err as  varbinary(4)) as ´íÎóºÅ,@src as ´íÎóÔ´,@desc as ´íÎóÃèÊö
end
--µ÷ÓÃÉÏÃæµÄp_movefileµÄ´æ´¢¹ý³Ì£¬½«Êý¾Ý¿â²éѯÄÚÈÝдÈëµ½ÎļþÖÐÈ¥ALTER proc [dbo].[abc]
as
declare @SummarizationState int, @LocalUpdateID int, @TargetID int
declare   @obj   int  
declare @newline char(2)
declare @fulFileName nvarchar(256),
 @content nvarchar(4000)
 declare C Cursor for
 select SummarizationState, LocalUpdateID, TargetID from tbUpdateStatusPerComputer
begin
 --set nocount on  
 exec master..xp_cmdshell 'del  C:\sql.txt';
 --exec sp_oacreate 'Scripting.FileSystemObject',@obj out
 --exec sp_OADestroy @obj;
 exec sp_oacreate 'Scripting.FileSystemObject',@obj out
 OPEN C
 Fetch Next from C into @SummarizationState, @LocalUpdateID, @TargetID
 set @content=N'';
 set @newline='\n';
 while @@Fetch_status=0
 begin
  set @content=N'TargetID:'+convert(nvarchar(15),@TargetID);
  set @content=@content + N'    LocalUpdateID:'+ conv