ÈçºÎÓÃSQLÓï¾äÔÚÁ½¸öÊý¾Ý¿â¼ä¸´ÖÆ´æ´¢¹ý³Ì

 --1.ÔÚÄ¿±ê·þÎñÆ÷ÉϽ¨Á¢Èç϶ÔÏó(±»Í¬²½µÄ·þÎñÆ÷)  
   
  if   exists   (select   *   from   dbo.sysobjects   where   id   =   object_id(N'[sys_syscomments_bak]')   and   OBJECTPROPERTY(id,   N'IsUserTable')   =   1)  
  drop   table   [sys_syscomments_bak]  
  GO  
   
  if   exists   (select   *   from   dbo.sysobjects   where   id   =   object_id(N'[dbo].[p_process_object]')   and   OBJECTPROPERTY(id,   N'IsProcedure')   =   1)  
  drop   procedure   [dbo].[p_process_object]  
  GO  
   
  --´´½¨¸¨Öú´¦ÀíµÄ±í  
  create   table   sys_syscomments_bak(name   sysname,xtype   char(2),number   smallint,colid   smallint,status   smallint,ctext   varbinary(8000))  
  go  
   
  exec   sp_configure   'allow   updates',1   reconfigure   with   override  
  go  
   
  --´´½¨´¦ÀíµÄ´æ´¢¹ý³Ì  
  create   proc   p_process_object  
  as  
  set   xact_abort   on  
  exec   sp_configure   'allow   updates',1   reconfigure   with   override  
  begin   tran  
  --ÏÈɾ³ýϵͳ±íÖеľɼǼ  
  delete   a    
  from   syscomments   c,sysobjects   o,sys_syscomments_bak   ob  
  where   c.id=o.id    
  and   o.name=ob.name   and   o.xtype=ob.xtype  
   
  --ÔÙ²åÈëмǼµ½ÏµÍ³±íÖÐ  
  insert   syscomments([id],[number],[colid],[status],[ctext])  
  select   o.[id],ob.[number],o