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  
Ïà¹ØÎĵµ£º
Ò»°ã½¨Ä£¿ÉÄܶ¼»áÓõ½£ºpowerdesigner
µ«ÊÇ£¬ÔÚ½¨±íµÄʱºò£¬ÎÒһֱûÓÐÕÒµ½£º
DEFAULT CHARACTER SET
COLLATE
Á½¸öÑ¡Ïî¡£Òò´Ë£¬ÏëÁ˸ö·½·¨£¬µã»÷£º¹¤¾ßÀ¸-¡·database-¡·edit current DBMS
È»ºó£¬Ñ¡ÖУºMYSQL50::Script\Objects\Table\Options
ÔÚoptionsĩβÌí¼Ó£º
ENGINE = %s : list = BDB | HEAP | ISAM | InnoDB ......
ÒÔÏÂÕâÆªÎÄÕÂÂÛÊöÉÏÔÚʲôÇé¿öÏÂ×Ó²éѯ±ÈÒ»°ãµÄÄÚÁ¬½Ó²éѯ¸ü¼Ó¿ìËÙ
http://www.mysqlperformanceblog.com/2010/03/18/when-the-subselect-runs-faster/
ÒÔÏÂÊÇÎÒ¶ÔmysqlµÄorder byºÍlimitÓÅ»¯µÄ½¨Ò飬ҪÊʱíµÄÊý¾ÝÁ¿ºÍÓÃÀ´¹ýÂËÁеÄΨһֵµÄ¸öÊý¶ø¶¨
£¨1£©where×Ó¾äÖÐÓÃÀ´¹ýÂ˽á¹ûµÄÁÐËùÔÚË÷ÒýµÄcadinalityºÜС£¬¼´ÓÃÏà¹Ø ......
µÚÒ»´Î²ÉÓÃMySQL×÷ΪҵÎñÓ¦ÓõÄÊý¾Ý¿â£¬ÓÉÓÚ¾Ñé²»¹»·á¸»£¬ÔÚ°²×°Êý¾Ý¿âµÄʱºòÑ¡ÔñÁËGB2312±àÂë¡£
ÆðÏÈÓõÄÒ²ËãµÃÐÄÓ¦ÊÖ£¬È»¶øºóÐø·¢ÏÖÁËÉúƧ×Ö²»ÄÜÏÔʾµÄÇé¿ö£¬°ÑÎÒ¸ãµÃ½¹Í·Àö¾¹ýºÃ¼¸ÌìµÄÃþË÷¡¢
ѧϰ£¬ÖÕÓÚ°ÑÎÊÌâ½â¾öÁË¡£¼ÇϽâ¾ö²½Ö裬Óë¸úÎÒÒ»ÑùµÄÐÂÊÖ·ÖÏí¡£
²½ÖèÒ»£º ·ÖÎö³öÏÖÂÒÂëµÄÔÒò
ÓÉÓÚGB2312×Ö·û¼¯Ö»ÊÕ ......
SqlServerÆô¶¯²ÎÊý
1.Sqlservr.exeÔËÐвÎÊý¡£
SqlServerµÄÆô¶¯¿ÉÒÔΪWindows·þÎñ·½Ê½£¨Ä¬ÈÏ£©£¬Ò²¿ÉÒÔÒÔÓ¦ÓóÌÐò·½Ê½Æô¶¯¡£ÏÂÃæ½éÉÜsqlservr.exeÒÔÓ¦ÓóÌÐò·½Ê½Æô¶¯Ê±µÄ²ÎÊýÎÊÌâ¡£
sqlservrÓ¦ÓóÌÐòÓ÷¨£º
sqlservr[-sinstance_name][-c][-dmaster_path][-f]
[-eerror_log_path][-lmaster_log_path][-m]
[-n][-Ttrace ......
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Êý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......