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

sqlserver ÖÐʹÓóÌÐò¼¯Assembly

                               **ÔÚsqlserverÖÐÈç¹ûҪʹÓÃÒ»¸ö³ÌÐò¼¯Ò»°ãÓÐÈçÏÂ×¢ÒâÊÂÏî 
Ò»£º´ò¿ªsqlserver µÄCLRÖ§³Ö
 
               --ÔÚSql ServerÖÐÖ´ÐÐÕâ¶Î´úÂë¿ÉÒÔ¿ªÆôCLR 
exec sp_configure 'show advanced options', '1';
go
reconfigure;
go
exec sp_configure 'clr enabled', '1'
go
reconfigure;
exec sp_configure 'show advanced options', '1'; 
go
¶þ£ºÊÇ·ñÐèÒª·ÃÎÊÍⲿ×ÊÔ´£¬Èç¹ûÐèÒª·ÃÎÊÍⲿ×ÊÔ´»¹ÐèÒªÖ´ÐÐÏÂÃæµÄ
     
  --´ò¿ªÊý¾Ý¿âµÄTRUSTWORTHY ÊôÐÔ
  ALTER DATABASE DB_Name set TRUSTWORTHY on;
 
 
 
 
**ÔÚsqlserverÖÐÈç¹ûҪʹÓÃÒ»¸ö³ÌÐò¼¯Ò»°ãÓÐÁ½ÖÖ·½·¨ 
 ·½·¨Ò»£ºÍ¨¹ýT-SQLÊÖ¶¯½«¸Ã³ÌÐò¼¯·ÅÈëµ½SQL Server Æä²½ÖèÈçÏÂ
Ò»£º´´½¨½«ÒªÊ¹ÓõijÌÐò¼¯.dll
   ³ÌÐòÉÏûʲôϡÆæµÄ£¬¸úÆÕͨµÄado.netµÄ³ÌÐò²î²»¶àÖ÷Òª¾ÍÊÇ·½·¨ÉϼÓÁËÒ»¸öÊôÐÔ  (<System.Data.Sql.SqlProcedure(name:="WriteHashedPassword")>)
 
¶þ£º²¿Êð³ÌÐò¼¯µ½sqlserver
             
                            a´ò¿ªsqlserverÖÐclrÖÐÏà¹ØµÄÖ§³Ö£¨·½·¨ÈçÉÏ£©
                
                             bÌí¼Ó³ÌÐò¼¯µ½sqlserver
                        


Ïà¹ØÎĵµ£º

SQLServerÈÕÆÚ¸ñʽ´úÂë

ת»»·½·¨£º convert(nvarchar(8),starttime,14)
    100   (1,   2)  
    ĬÈÏÉèÖà  
    mon   dd   yyyy   hh:miAM£¨»ò   PM£©     
    
    101  
&nbs ......

Óû§"sa "µÇ½ʧ°Ü SQLServer ´íÎó18456

ÓÃwindowsÕ˺Ż¹ÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂԱ༭Æ÷£¬»úËã»úÅ ......

ÔÚSqlServer´æ´¢¹ý³ÌÖÐʹÓÃCursor£¨Óα꣩²Ù×÷¼Ç¼

 
1. ΪºÎʹÓÃÓα꣺
    
ʹÓÃÓαê(cursor)µÄÒ»¸öÖ÷ÒªµÄÔ­Òò¾ÍÊǰѼ¯ºÏ²Ù×÷ת»»³Éµ¥¸ö¼Ç¼´¦Àí·½Ê½¡£ÓÃSQLÓïÑÔ´ÓÊý¾Ý¿âÖмìË÷Êý¾Ýºó£¬½á¹û·ÅÔÚÄÚ´æµÄÒ»¿éÇøÓòÖУ¬ÇÒ½á¹û
ÍùÍùÊÇÒ»¸öº¬Óжà¸ö¼Ç¼µÄ¼¯ºÏ¡£Óαê»úÖÆÔÊÐíÓû§ÔÚSQL serverÄÚÖðÐеطÃÎÊÕâЩ¼Ç¼£¬°´ÕÕÓû§×Ô¼ºµÄÒâÔ¸À´ÏÔʾºÍ´¦ÀíÕ ......

̸JDBC SQLSERVER"Error establishing socket"

 
jdbcÅäÖÃÓï¾äΪ: jdbc:microsoft:sqlserver://server_name:1433
ÈçÔËÐгÌÐòʱ³öÏÖ "Error establishing socket" ´íÎó,ÔòÓ¦½øÐÐÈçϵ÷ÊÔ:
1 ¼ì²éSQL SERVER ÊÇ·ñÔÊÐíÔ¶³Ì·ÃÎÊ.¾ßÌå²½Öè:
1)´ò¿ª"ÆóÒµ¹ÜÀíÆ÷",´ò¿ª¿ØÖÆ̨¸ùĿ¼>SQL Server ×é>Êý¾Ý¿â
2)ÔÚÏàÓ¦"Êý¾Ý¿â"Éϵ¥»÷ÓÒ¼ü,Ñ¡Ôñ"ÊôÐÔ"
3)Ñ¡Ôñ"Á¬½Ó"Ñ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ