Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlµ¼³öÊý¾Ý¿âʱ±¨ "µÇ½ xxx ʧ°Ü",ÎÞ·¨Íê³É

ÐÞ¸ÄÊý¾Ý¿â¶ÔÏóËùÓÐÈË
½ñÌì°ïÅóÓÑ´«Êý¾Ý¿â±¨´í,Ìáʾ "
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]µÇ½ xxx ʧ°Ü",ÕýºÃǰ¶Îʱ¼äÅöµ½Í¬ÑùÎÊÌâ,³¢ÊÔɾ³ýÓû§ xxx , ÓÖ±¨´í,Ìáʾ" Óû§ÓµÓжÔÏó,ËùÒÔÎÞ·¨É¾³ý". ²é¿´Êý¾Ý¿â,·¢ÏÖ¸ÃÓû§ÓµÓÐºÜ¶à´æ´¢¹ý³Ì,Ò»¸öÒ»¸ö¸ÄÌ«Âé·³,´ÓÍøÉÏÕÒµ½ÈçÏ·½·¨,Ç¡ºÃ½â¾ö´ËÎÊÌâ:
CREATE   PROCEDURE   dbo.User_ChangeObjectOwnerBatch  
  @OldOwner as   NVARCHAR(128),  
  @NewOwner as   NVARCHAR(128)  
  AS  
   
  DECLARE   @Name   as   NVARCHAR(128)  
  DECLARE   @Owner as   NVARCHAR(128)  
  DECLARE   @OwnerName as   NVARCHAR(128)  
   
  DECLARE   curObject   CURSOR   FOR    
  select 'Name' =   name,  
  'Owner' =   user_name(uid)  
  from   sysobjects  
  where   user_name(uid)=@OldOwner  
  order   by   name  
   
  OPEN     curObject  
  FETCH   NEXT   from   curObject   INTO   @Name,   @Owner  
  WHILE(@@FETCH_STATUS=0)  
  BEGIN          
  if   @Owner=@OldOwner    
  begin  
  set   @OwnerName   =   @OldOwner   +   '.'   +   rtrim(@Name)  
  exec   sp_changeobjectowner   @OwnerName,   @NewOwner  
  end  
  -- select   @name,@NewOwner,@OldOwner  
   
  FETCH   NEXT   from   curObject   INTO   @Name,   @Owner  
  END  
   
  close   curObject  
  deallocate   curObject   
        
  GO  
È»ºóÖ´Ðд洢¹ý³Ì¼´¿É
exec User_ChangeObjectOwnerBatch


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

¹ØÓÚÓÃADO.NET »ñÈ¡ SQL SERVER ±í SCHEMAµÄһЩ¼Ç¼

×îÏÈÏ£ÍûʹÓÃdatatable.columnsÖÖËùº¬ÓеÄÊôÐÔÖ±½Ó»ñÈ¡Ïà¹ØÐÅÏ¢£¬¿É²âÊÔºó·¢ÏÖ£¬³ýÁË×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬ÆäËûÊý¾ÝÒ»¸ÅÕÒ²»µ½¡£
GOOGLEÍøÉϺܶàÖÖ·½·¨£¬ÆäÖÐ×îÖ±½ÓµÄÊÇÖ±½Ó²éѯSQLSERVERµÄinformation_schema.columsÊÓͼ£¬´ÓÖÐÖ±½Ó»ñÈ¡ÐÅÏ¢£¬²»¹ýºóÀ´ÓÖ·¢ÏÖ£¬ËäÈ»Êý¾ÝʱȫÁË£¬¿ÉÊÇÐèҪͨ¹ýºÜ¸´Ôӵķ½·¨£¨sys.all_columns sys ......

Knowledge Xpert® for PL/SQL ¼ò½é

Knowledge Xpert® for PL/SQL ÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄ»ùÓÚWindowsµÄ¼¼Êõ×ÊÔ´¿â£¬Ëü¸²¸ÇPL/SQL ¿ª·¢µÄÕû¸öÉúÃüÖÜÆÚ£¬ÉÏǧÖÖרÌâÌṩ±àд¸ßÖÊÁ¿´úÂëËùÐèÒªµÄ±³¾°ÐÅÏ¢¡¢×îºÃµÄ¾­ÑéºÍ³ÌÐò·¶Àý¡£
ÌṩÉÏǧÖÖרÌ⣬¸²¸ÇPL/SQL ±à³ÌµÄÕû¸öÉúÃüÖÜÆÚ£¬´Ó»ù±¾µÄרÌâµ½¸ß¼¶µÄPL/SQL ±àÂë¼¼Êõ¡£
ÓɰüÀ¨Mike Ault¡¢Steven Feuerstein¡¢ ......

oralce sqlÓÅ»¯34Ìõ

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......

¸ü¸ÄSQL ServerĬÈϵÄ1433¶Ë¿Ú

1.SqlServer·þÎñʹÓÃÁ½¸ö¶Ë¿Ú£ºTCP-1433¡¢UDP-1434¡£ÆäÖÐ1433ÓÃÓÚ¹©SqlServer¶ÔÍâÌṩ·þÎñ£¬1434ÓÃÓÚÏòÇëÇóÕß·µ»ØSqlServerʹÓÃÁËÄǸöTCP/IP¶Ë¿Ú¡£
¿ÉÒÔʹÓÃSQL ServerµÄÆóÒµ¹ÜÀíÆ÷¸ü¸ÄSqlServerµÄĬÈÏTCP¶Ë¿Ú¡£·½·¨ÈçÏ£º
a¡¢´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÒÀ´ÎÑ¡Ôñ×ó²à¹¤¾ßÀ¸µÄ“Microsoft SQL Servers - SQL Server×锣¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ