Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

sql server 2005°²×°¹ý³ÌÖÐÓöµ½µÄһЩÎÊÌâ

°²×°µÄ×é¼þºÍ°æ±¾µÄÐÅÏ¢
Microsoft SQL Server Management Studio      9.00.1399.00
Microsoft Analysis Services ¿Í»§¶Ë¹¤¾ß      2005.090.1399.00
Microsoft Êý¾Ý·ÃÎÊ×é¼þ (MDAC)      6.1.7600.16385 (win7_rtm.090713 ......

ÔÚSQLÖÐʹÓÃnow()µ¼ÖµÄÐÔÄÜϽµ(MySQL)

×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈ˰¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷ ......

ÂÛ̳Àï¿´µ½µÄÒ»¸öSQLÎÊÌâ¼°½â´ð

ÎÊÌ⣺
ÓÐÒ»¸ö·ÖÊý±í
id classid,score
1  01    120
2  01    128
3  02    98
4  04    134
5  04    78
ÏÖÔÚҪͳ¼Æ ¸÷°àscore >120,ºÍ´óÓÚ90·ÖµÄÈËÊý
´ïµ½ÈçÏÂЧ¹û
classid >120 >90
01  &nb ......

eclipse ¹ØÁª sql server µÄJDBCÎÊÌâ

eclipse ¹ØÁª sql server µÄJDBCÎÊÌâ
±à³ÌÔËÐкóÌáʾ£º
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
ÉÏÍø²éÁË£¬ÓеÄ˵ÔÚ»·¾³±äÁ¿ÀïµÄclasspathÌí¼Ó JDBCÀïµÄ3¸öjarÎļþ¾Í¿ÉÒÔ£¬µ«ÊÇʹÓúó»¹ÊDz»ÐС£
ºóÀ´²ÅÖªµÀ½â¾ö·½·¨£º
°ü×ÊÔ´¹ÜÀíÆ÷-->°üÃûÓÒ¼ü"¹¹½¨Â·¾¶"--> ......

Knowledge Xpert® for PL/SQL ¼ò½é

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