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Óöµ½ºÜ¶àÂé·³£¬ÏëÏóÔÒò£¬×Ô¼º»¹ÊÇlinuxµÄ³õѧÕߣ¬Í¬Ê±ÊÜ´ìʱ×ÜÊÇÒª°ÑÎÊÌâµÄ¸´ÔÓϵÊý·Å´ó¡£
1 °²×°³åÍ»
¸ù¾Ý¡¶linux³ÌÐòÉè¼Æ¡·ÉϵÄÖ¸µ¼£¬´Ó¹ÙÍøÏÂÔØÁËmysql-server-xx£¬mysql-devel-xx£¬mysql-client-xx£¬mysql-share-xx£¬È»ºóÖ´ÐÐ
rpm -i *.rpm
½á¹û¶þÊ®¼¸ÐÐconflictÌáʾ£¬ËµÓÐÎļþÓëmysql-server-xxµÄ°² ......
dblpÊý¾Ý¿âÖÐÒýÓÃÐÅÏ¢ºÜÉÙ£¬Æ½¾ùһƪÂÛÎÄÒýÓÃ0.2ƪ¡£Ê¹ÓÃdblp×öʵÑéÊý¾Ý¼¯µÄijƪÂÛÎÄÌáµ½£¬¿ÉÒÔËæ»úÌí¼ÓÒýÓÃÐÅÏ¢¡£ÊÜ´ËÆô·¢£¬ÎÒ´òËãΪÿһƪÂÛÎͼÌí¼Ó20ÆªËæ»úÒýÓã¬ÓÚÊǾÍд³öÁËÈçϵÄsqlÓï¾ä£º
String sql = "insert into citation(pId1,pId2) values( (selec ......
×òÌìΪһ¸öÏîÄ¿×öÊý¾Ý¿â£¬ÏîÄ¿Éæ¼°µ½¶©µ¥£¬ÔÚÉè¼ÆÊý¾Ý¿â×ÖµäµÄʱºò ¾Í°ÑÕâ¸ö±íÃû¶¨ÎªÁËorder£¬½¨±íµÄʱºòÔõô½¨¶¼²»¶Ô£¬ÌáʾÊDZíÃû¸½½ü³öÏÖÎÊÌ⣬µ±Ê±¾õµÃ²»¿ÉÄܰ¡ Ò²ÐíÊÇ×Ö¶ÎÀàÐÍÄĶù³öÁËÎÊÌ⣬²éÁ˺þã¬ÊÔÁ˺ü¸´Î£¬»¹ÊDz»ÐУ¬ºóÀ´Í»È»»ÐÈ»´óÎò£¬order byÊÇÅÅÐòÓï¾ä£¬order¿Ï¶¨ÊDZ£Áô×Ö£¬Ôõô¿ÉÄÜ×ö±íÃûÄØ¡£¡£¡£Á¢¼´°Ñ±í ......
ojdbc14.jarÓëclasses12.jarÓÐÊ²Ã´Çø±ð??
×î½üÓÃclasses12.jar£¬hibernate3.1ÀÏÊdzöÎÊÌ⣿
ÎÒµÄoracle9.2.0.10!
ÔÚÍøÉÏÕÒ£¬·¢ÏÖÓÐÈËÓÃojdbc14.jar¿ª·¢£¬Ã»ÓÐÓùýÄØ£¿¿´oracleµÄreadme.txtҲûÓп´Ê²Ã´ÄØ£¿
ÄÇλ´ó¸çÖªµÀ˵һÏ£¡Ê®·Ö¸Ðл£¡
------------------------------------------------------------------------- ......
PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔÒò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕß¶¼Í³Ò»²ÅÐУ ......