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

sqlserverºÍmysqlµÄÐÐתÁÐͨÓô洢¹ý³Ì

sqlserverÖУº
  1 /*
  2 1 * Description:¶ÔÊý¾Ý±í½øÐÐÐÐÁÐת»»
  3 2 * Author:llf
  4 3 * µ÷ÓÃ˵Ã÷£ºexec SP_RowChangeCol 'ѧÉú³É¼¨±í','ÐÕÃû','¿Î³Ì','·ÖÊý','desc',0,0,'where Äê¼¶=''Ò»Äê¼¶'''
  5 4 * ¸Ã´æ´¢¹ý³Ìµ÷ÓõÄÏà¹Øº¯Êý£ºdbo.Get_StrArrayLength(@groupCol,',')£»dbo.dbo.Get_StrArrayStrOfIndex(@groupCol,',',1)
  6 */
  7  
  8 Alter proc SP_RowChangeCol
  9  @tableName varchar(100),    --Ҫת»»µÄÊý¾Ý±íÃû(ѧÉú³É¼¨±í)
 10  @groupCol varchar(100),     --·Ö×éÁÐ(ѧÉúÐÕÃû)
 11  @changeCol varchar(100),    --Ҫת»»µÄÁÐ(¿¼ÊÔ¿ÆÄ¿)
 12  @countCol varchar(100),     --ͳ¼ÆÁÐ(³É¼¨)
 13  @orderby varchar(4),        --ת»»ÁеÄÅÅÐò¹æÔò(ÉýÐòasc,½µÐòdesc)
 14  @isColSum int,              --ÊÇ·ñͳ¼ÆÁУ¨1ÊÇ£»0·ñ£©
 15  @isRowSum int,              --ÊÇ·ñͳ¼ÆÐУ¨1ÊÇ£»0·ñ£©
 16  @strWhere varchar(max)         --²éѯÌõ¼þ('where Äê¼¶=''Ò»Äê¼¶''')
 17  as
 18  begin
 19      declare @sqlhead varchar(8000),@sqlend varchar(8000)
 20       ,@sql1 varchar(8000),@sql2 varchar(8000),@sql3 varchar(8000),@sql4 varchar(8000)
 21       ,@i int,@ic varchar(20),@sql varchar(1000)
 22 
 23 
 24  


Ïà¹ØÎĵµ£º

mysqlÖ÷´ÓÅäÖÃһЩעÒâ

ÅäÖÃÖ÷´Ó£º
Á½Ì¨·þÎñÆ÷mysql°æ±¾Ò»Ñù£¬
Server version: 5.1.16-beta-log MySQL Community Server
ÅäÖûù±¾Ò»Ñù¡¢Æô¶¯²ÎÊýÒ»Ñù
Ö÷µÄ¿ÉÒÔ·ÃÎʴӵģ¬
µ«ÊÇ
´ÓÄDZßÔõôÁ¬½ÓÖ÷µÄ£¬¶¼ÊÇʧ°Ü£º
[root@2006 htmlfile]# mysql -h192.168.xx.xxx -uxxx -pxxx --default-character-set=GBK --reconnect
ERROR 2003 (HY000): C ......

mysqlËæ»úÊý¾ÝÉú³É²¢²åÈë

      dblpÊý¾Ý¿âÖÐÒýÓÃÐÅÏ¢ºÜÉÙ£¬Æ½¾ùһƪÂÛÎÄÒýÓÃ0.2ƪ¡£Ê¹ÓÃdblp×öʵÑéÊý¾Ý¼¯µÄijƪÂÛÎÄÌáµ½£¬¿ÉÒÔËæ»úÌí¼ÓÒýÓÃÐÅÏ¢¡£ÊÜ´ËÆô·¢£¬ÎÒ´òËãΪÿһƪÂÛÎͼÌí¼Ó20ÆªËæ»úÒýÓã¬ÓÚÊǾÍд³öÁËÈçϵÄsqlÓï¾ä£º
     String sql = "insert into citation(pId1,pId2) values( (selec ......

¹ØÓÚmysql¹Ø¼ü×Ö

×òÌìΪһ¸öÏîÄ¿×öÊý¾Ý¿â£¬ÏîÄ¿Éæ¼°µ½¶©µ¥£¬ÔÚÉè¼ÆÊý¾Ý¿â×ÖµäµÄʱºò ¾Í°ÑÕâ¸ö±íÃû¶¨ÎªÁËorder£¬½¨±íµÄʱºòÔõô½¨¶¼²»¶Ô£¬ÌáʾÊDZíÃû¸½½ü³öÏÖÎÊÌ⣬µ±Ê±¾õµÃ²»¿ÉÄܰ¡ Ò²ÐíÊÇ×Ö¶ÎÀàÐÍÄĶù³öÁËÎÊÌ⣬²éÁ˺þã¬ÊÔÁ˺ü¸´Î£¬»¹ÊDz»ÐУ¬ºóÀ´Í»È»»ÐÈ»´óÎò£¬order byÊÇÅÅÐòÓï¾ä£¬order¿Ï¶¨ÊDZ£Áô×Ö£¬Ôõô¿ÉÄÜ×ö±íÃûÄØ¡£¡£¡£Á¢¼´°Ñ±í ......

jdbc sqlserver oracle Çý¶¯ÎÊÌ⼯½õ

ojdbc14.jarÓëclasses12.jarÓÐÊ²Ã´Çø±ð??
×î½üÓÃclasses12.jar£¬hibernate3.1ÀÏÊdzöÎÊÌ⣿
ÎÒµÄoracle9.2.0.10!
ÔÚÍøÉÏÕÒ£¬·¢ÏÖÓÐÈËÓÃojdbc14.jar¿ª·¢£¬Ã»ÓÐÓùýÄØ£¿¿´oracleµÄreadme.txtҲûÓп´Ê²Ã´ÄØ£¿
ÄÇλ´ó¸çÖªµÀ˵һÏ£¡Ê®·Ö¸Ðл£¡
------------------------------------------------------------------------- ......

pbÁ¬½ÓmySqlÊý¾Ý¿â

PBÁ¬½ÓMySQLÊý¾Ý¿â
 
È¥mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØodbc connector(http://dev.mysql.com/downloads/connector/odbc/)
ÏÂÔØµÄÊÇmysql-connector-odbc-noinstall-5.1.6-win32.zip
½âѹºóÖ±½ÓÔËÐÐÎļþ¼ÐÖÐµÄ Install.bat Åú´¦ÀíÎļþ
mysql-connectorÓкü¸ÖÖ£¬Ñ¡ÔñÒ»¸ö×Ô¼ºÏ²»¶µÄ¼´¿É¡£
ÔÚxpÖдò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ