SQLÈßÓà×ֶεIJßÂԺ͹ÜÀí
SQLÈßÓà×ֶεIJßÂԺ͹ÜÀí
http://www.examda.com/ncre/three/db/fudao/20091203/093528816.html
ÈßÓà×ֶεÄʹÓÃÔÚ¶à±íÁªºÏ²éѯ¶¼ÊÇ´óÊý¾ÝÁ¿µÄ±íµÄÇé¿öÏ£¬È·ÊµÊǸö²»´íµÄÑ¡Ôñ£¬ÓÐЧµÄ¼õÉÙÁËIO²Ù×÷¡£µ«½áºÏÒÑÓеÄÏîÄ¿²úÆ·À´¿´£¬ÈßÓà×Ö¶ÎȷʵÊÇË«Èн£¡£ÓÈÆäÊÇ´óÏîÄ¿µÄ¿ª·¢£¬Èç¹ûºöÂÔij¸ö±íµÄÈßÓà×ֶεĸüУ¬ÄÇôºó¹ûÊÇÔÖÄÑÐԵġ£ÈçºÎÓÐЧµÄ¹ÜÀíÈßÓà×Ö¶ÎÊÇ¿ª·¢×éÄÚ±ØÐë½â¾öµÄÎÊÌâ¡£ÎҵĽâ¾ö·½°¸ÊÇ£ºÊ¹ÓÃרÃŵıíÀ´¹ÜÀíÈßÓà×ֶΡ£ÀýÈçarticle±íÓÐÒÔÏÂÈßÓà×Ö¶Î
¡¡¡¡fromUserName,toUserName
¡¡¡¡ÈçºÎ¹ÜÀíÕâÁ½¸ö×Ö¶ÎÄØ£¿Í¨¹ý½¨Á¢Ò»¸ö±í£¬±í½á¹¹ÈçÏÂ
¡¡¡¡id,objTable,objName,sourceTable, sourceId,level£¬isUpdate
¡¡¡¡ÆäÖÐobjTable=Ä¿±ê±í£¬objName= Ä¿±ê×ֶΣ¬sourceTable=Ô´±í,sourceId=Ô´±íID,level=ÊÇ·ñÐèÒªÁ¢¼´¸üÐÂ,isUpdate=ÊÇ·ñÒѸüÐÂ
¡¡¡¡ÆäÖУ¬level×ֶκÜÓбØÒª£¬ÓÐЩÈßÓà×ֶβ¢²»ÐèÒªÔÚÔ´±íÐ޸ĺóÁ¢¼´¸üУ¬ÄÇô¿ÉÒÔͨ¹ýÒ»¸ö¶¨ÆÚ¸üвßÂÔÀ´¸üС£
¡¡¡¡Í¨¹ý¿â±íµÄ¹ÜÀí£¬ÅäºÏÒ»¸öºÏÀíµÄ´æ´¢¹ý³Ì£¬ÈßÓà×ֶεÄʹÓý«²»ÔÙÊÇÄÑÌâ¡£
¡¡¡¡¾ÙÀý£¬Èç¹ûÉÏÃæÁ½¸ö×ֶη¢Éú±ä»¯£¬ÔòʹÓô¥·¢Æ÷»òÕßµ÷ÓÃÕâ¸ö´æ´¢¹ý³ÌÀ´¼ì²éÊÇ·ñÓÐÐèÒªÁ¢¼´¸üеÄÈßÓà×ֶΣ¬ÐèÒªÔòÁ¢¼´¸üУ¬²»ÐèÒªÔòisUpdateÖÃ0,µÈµ½ÖÜÆÚÐԵIJßÂÔÀ´¸üÐÂͬʱisUpdate=1¡£
¡¡¡¡Èç¹ûÏîÄ¿ÖÐʹÓÃÁËmemcache,Ôò»¹¿ÉÒÔʹÓÃÁíÒ»¸ö˼·À´½øÒ»²½¼õСÊý¾Ý¿âIO²Ù×÷¡£ÏÂƪÔÙÕ¹¿ªÀ´Ëµ¡£
Ïà¹ØÎĵµ£º
CREATE OR REPLACE PACKAGE BODY PACK_RISK_FUNCTION AS
--- 1 ½«·ûºÅÌæ»»³É#ºÅ »òÐí¿ÉÒÔÓÃÕýÔò±í´ïʽ£¬µ«ÊÇÏÓÂé·³»¹ÊÇÖ±½ÓÓÃÌæ»»
FUNCTION CHANGE_OPERATOR(FORMULA VARCHAR2)
RETURN VARCHAR2
AS
V_FORMULA VARCHAR2(100);
BEGIN
V_FORMULA := REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(FORMULA,'(',''), ......
²Ù×÷²½ÖèÈçÏ£¬¹©²Î¿¼¡£
Êý¾Ý¿âתÐ͹¤×÷Éæ¼°µÄ¹¤×÷ÊÂÏî·ÖÎö£º±í£¬±íÊý¾Ý£¬Ë÷Òý£¬Íâ¼üÔ¼Êø£¬×Ö¶ÎĬÈÏÖµ¡£
´æ´¢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷¡¢ÊÓͼµÈÓÉÓÚÓï·¨´æÔÚ²îÒ죬ֻÄÜ×ÔÐиÄд´¦Àí¡£
(Ò»)ÔÚMS SQL SERVER·þÎñÆ÷¶ËµÄ×¼±¸¹¤×÷¡£
1).´´½¨¹ØÓÚ±í¡¢ÊÓͼ¡¢Ö÷¼ü¡¢Ë÷Òý¡¢×Ö¶Î×ֵ䡢ĬÈÏÖµÔ¼ÊøµÄ¶ÔÏóÊÓͼ¡£ÒÔ·½±ãÏÂÒ»²½ ......
ÔÚÈí¼þ¿ª·¢ÖУ¬³£³£ÐèҪΪ³ÌÐò½¨Á¢Sql ServerÊý¾Ý¿âµÄÔËÐл·¾³¡£Íê³ÉÈçÔÚSQL ServerÊý¾Ý¿âÖн¨Á¢É豸£¬½¨Á¢Êý¾Ý¿â£¬½¨Á¢±í¸ñ£¬·ÖÅäȨÏ޵ȹ¦ÄÜ£¬ÈçºÎ·½±ãµÄ½¨Á¢Ó¦ÓóÌÐòËùÐèSql Server»·¾³µÄÊý¾Ý¿â»·¾³£¬¶ø²»ÓÃÆô¶¯SQL Enterprise ManagerÄØ£¿
ÏÂÃæÀ´¿´£º
¡¡¡¡Æô¶¯VB6.0£¬Ð½¨Ò»¸ö¹¤ ......
·ÀSQLÊý×Ö×¢È뺯Êý
http://blog.csdn.net/cncco/archive/2007/10/03/1810540.aspx
·ÀSQL×¢È뺯Êý
³ÌÐò´úÂ룺
º¯Êý²¿·Ö========================================================================
'------------------------------------------------
'ÓÃ;:¼ì²éÊÇ·ñΪÊý×Ö,ÒÔ¼°Êý×ÖÊÇ·ñ³¬³ö·¶Î§
'ÊäÈë:¼ì²é×Ö·û,´ ......
'*************************************************************************
'**Ä£ ¿é Ãû£ºfBackupDatabase_a
'**Ãè Êö£º±¸·ÝÊý¾Ý¿â,·µ»Ø³ö´íÐÅÏ¢,Õý³£»Ö¸´,·µ»Ø""
'**µ÷ ÓãºfBackupDatabase_a "±¸·ÝÎļþÃû","Êý¾Ý¿ ......