ÔÚ×öSQL¹ÊÕÏתÒÆȺ¼¯µÄʱºòÓ¦¸ÃÑ¡ÔñÄÄÖÖģʽ£¿
Èç¹ûÎÒÃǵÄSQL ServerÒª±£Ö¤¸ß¿ÉÓÃÐÔ£¬ÄÇô¿ÉÒÔ²ÉÓùÊÕÏתÒÆȺ¼¯¡£×î¼òµ¥µÄ¹ÊÕÏתÒÆȺ¼¯ÊÇÁ½Ì¨·þÎñÆ÷£¬Ò»Ì¨×ö»î¶¯µÄ·þÎñÆ÷£¬Áíһ̨×ö±¸Ó÷þÎñÆ÷£¬Õâ¾ÍÊÇAPģʽµÄCluster¡£ÁíÍâÒ»¸öģʽ¾ÍÊÇAAģʽ£¬Ò²¾ÍÊÇÁ½Ì¨·þÎñÆ÷¶¼ÊÇÔËÐÐSQL ServerʵÀý¡£
SQL Server²»ÏñOracleÒ»ÑùÓÐRAC£¬ËùÒÔ²»¿ÉÄÜ˵Á½Ì¨·þÎñÆ÷ͬʱÔËÐÐͬһ¸öʵÀý£¬ÏëÒªÁ½Ì¨·þÎñÆ÷¶¼Ê¹ÓÃÆðÀ´µÄ»°£¬ÄÇôֻÓи÷×ÔÔËÐÐÒ»¸öʵÀý¡£
ÄÇôÎÒÃÇÆóÒµÀïÃæÒª×öClusterµÄʱºò£¬µ½µ×Ó¦¸Ã×öAPģʽµÄ»¹ÊÇ×öAAģʽµÄÄØ£¿
APģʽÊÇÔÚÁ½Ì¨·þÎñÆ÷ÉÏ°²×°Ò»¸öÊý¾Ý¿âʵÀý£¬Ö»ÓÐһ̨·þÎñÆ÷¸ºÔð¸ÃÊý¾Ý¿âʵÀýµÄÈ«²¿ÔËËãºÍ²Ù×÷£¬ÁíÍâһ̨·þÎñÆ÷ÏÐÖᣵ±»î¶¯µÄ·þÎñÆ÷·¢Éú¹ÊÕÏʱ£¬ÏµÍ³×Ô¶¯Æô¶¯Áíһ̨·þÎñÆ÷µÄʵÀý£¬ÊµÏÖ¹ÊÕÏתÒÆ¡£APģʽµÄ×î´óȱµã¾ÍÊÇ×ÊÔ´ÀûÓÃÂʵͣ¬Ö»ÓÐһ̨·þÎñÆ÷ÔÚ±»Ê¹Óá£
AAģʽÊÇÔÚÁ½Ì¨·þÎñÆ÷ÉÏ°²×°Á½¸öÊý¾Ý¿âʵÀý£¬Ã¿Ì¨·þÎñÆ÷·Ö±ðÔËÐÐÒ»¸öÊý¾Ý¿âʵÀý¡£µ±Ä³Ò»Ì¨·þÎñÆ÷·¢Éú¹ÊÕÏʱϵͳ½«°Ñ·¢Éú¹ÊÕϵķþÎñÆ÷ÉϵÄÊý¾Ý¿âʵÀýÇл»µ½Áíһ̨·þÎñÆ÷ÉÏÔËÐУ¬Ò²¾ÍÊÇ˵Áíһ̨·þÎñÆ÷ÉÏͬʱÔËÐÐÁ½¸öʵÀý£¬µ±·þÎñÆ÷»Ö¸´Õý³£ºóÔÙÊÖ¶¯½«Ò»¸öÊý¾Ý¿âʵÀýÇл»»ØÁíһ̨·þÎñÆ÷¡£AAģʽ±£Ö¤ÁËÁ½Ì¨·þÎñÆ÷×ÊÔ´¶¼±»ÀûÓá£
¹ØÓÚ1¸öÊý¾Ý¿âʵÀýÖÐ2¸öÊý¾Ý¿âºÍ2¸öÊý¾Ý¿âʵÀýÖи÷1¸öÊý¾Ý¿âµÄÇø±ð£º
1. 1¸öÊý¾Ý¿âʵÀýÖеÄ2¸öÊý¾Ý¿â¶¼±ØÐëÔËÐÐÔÚͬһ̨·þÎñÆ÷ÉÏ£¬ËùÒÔÈç¹û2¸öÊý¾Ý¿â¶¼¾ßÓдóÁ¿µÄÔËËãÕ¼ÓôóÁ¿µÄ×ÊÔ´£¬Ôò¿ÉÄÜÔì³ÉÊý¾Ý¿â·þÎñÆ÷ѹÁ¦¹ý´ó£¬ÔËÐлºÂý£»¶ø2¸öʵÀýÖи÷1¸öÊý¾Ý¿âÔò¿ÉÒÔ½«Ã¿¸öʵÀý²¿ÊðÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ£¬¸÷×ÔʹÓø÷×Ô·þÎñÆ÷µÄ×ÊÔ´£¬Ï໥ûÓÐÓ°Ïì¡£
2. 1¸öʵÀýÖÐ2¸öÊý¾Ý¿âµÄÏ໥·ÃÎʱȽϼòµ¥£¬¿ÉÒÔ¶Ô2¸öÊý¾Ý¿â½øÐÐÊÂÎñ²Ù×÷£»¶ø2¸öʵÀýÖеÄÊý¾Ý¿âÒªÏ໥·ÃÎÊÔòÐèҪͨ¹ýÁ´½Ó·þÎñÆ÷»òÕßÆäËû·½Ê½À´·ÃÎÊ£¬Èç¹ûÒªÔÚ2¸öʵÀýÖнøÐÐÊÂÎñ²Ù×÷ÔòÐèÒªÆôÓ÷ֲ¼Ê½ÊÂÎñMSDTC£¬Ê¹Ó÷ֲ¼Ê½ÊÂÎñ½«»áʹÊÂÎñʱ¼ä±ä³¤£¬ÊÂÎñ³öÏÖ´íÎóµÄ¿ÉÄܸü´ó£¬ÉõÖÁ³öÏÖ¸÷ÖÖÁéÒìµÄ´íÎó£¬ËùÒÔÒ»°ã²»ÍƼöʹÓ÷ֲ¼Ê½ÊÂÎñ¡£
ËùÒÔ£¬Èç¹ûÎÒÃÇÔÚÓÐ×ã¹»×ÊÔ´£¨Ò²¾ÍÊǺÜÓÐÇ®µÄÒâ˼£©µÄÇé¿öÏ£¬¶øÇÒÏë¼òµ¥Ò»µã£¬ÄÇôÎÒÃǾÍ×öAPģʽ¡£±Ï¾¹AAģʽ±ÈAPģʽ¸ü¸´ÔÓ£¬¸üÄÑÓÚ¹ÜÀí¡£Èç¹ûÎÒÃÇÏë³ä·ÖÀûÓ÷þÎñÆ÷×ÊÔ´£¬·þÎñÆ÷ÓÐÏÞ£¬¶øÇÒ¶à¸öÊý¾Ý¿âÖ®¼ä²»´æÔÚ·Ö²¼Ê½ÊÂÎñµÄ»°£¬ÄÇôÓÃAAģʽÊÇÒ»¸ö²»´íµÄÑ¡Ôñ¡£
ÒÔÒÔÇ°µÄ¾ÑéÀ´¿´£¬×îºÃ²»ÒªÊ¹Ó÷ֲ¼Ê½ÊÂÎñ£¬»áÓöµ½¸÷ÖÖ¸÷ÑùÁéÒìµÄÎÊÌâ¡£
Ïà¹ØÎĵµ£º
ͨÅä·û_
"_"ºÅ±íʾÈÎÒâµ¥¸ö×Ö·û,¸Ã·ûºÅÖ»ÄÜÆ¥ÅäÒ»¸ö×Ö·û."_"¿ÉÒÔ·ÅÔÚ²éѯÌõ¼þµÄÈÎÒâλÖÃ,ÇÒÖ»ÄÜ´ú±íÒ»¸ö×Ö·û.Ò»¸öºº×ÖֻʹÓÃÒ»¸ö"_"±íʾ.
Àý×Ó£º
if PATINDEX('%[ß¹-×ö]%','ÐèÒªÅжϵÄ×Ö·û')>0 -- ÅжÏÊÇ·ñÓÐ×Ö·û
print 'Óкº×Ö'
else
print 'ÎÞºº×Ö'
ͨÅä·û%
"%"·ûºÅÊÇ×Ö·ûÆ¥Åä·û,ÄÜÆ¥Åä0¸ö»ò¸ü¶à×Ö·ûµÄÈÎÒⳤ¶ ......
1.Ê×ÏÈÐèÒª½¨Á¢plan table,·ñÔò²»ÄÜʹÓÃ
½¨Á¢·½·¨£º
$oracle\rdbms\adminÏÂÓиö
utlxplan.sql
ÆäÄÚÈÝΪ:
create table PLAN_TABLE (
statement_id varchar2(30),
timestamp date,
remarks varchar2(80),
operat ......
ÔÀí£º¶ÔÐèҪȥÖظ´¼Ç¼µÄ×ֶΰ´×éÅÅÐò£¬È»ºóÈ¡ÆäÖÐÒ»Ìõ¼Ç¼¡£ÔÚ×ܲéѯÓï¾äÖÐʹÓÃinÓï·¨¹ýÂË
È¥µôÖظ´¼Ç¼
select * from company where comid in (select Max(comid) from company group by companyname)
µÃµ½Öظ´¼Ç¼Êý
select * from company where comid not in (select Max(comid) from company group by companyn ......
ÔÚʹÓÃSQL*PlusÉú³É±¨¸æÎļþµÄʱºò£¬ÍùÍù»áÒòΪÆäĬÈϵÄÉèÖõ¼ÖÂÊä³öµÄ½á¹û·Ç³£µÄûÓпɶÁÐÔ£¬ÏÂÃæ½éÉÜÒ»¸öÈÕ³£ÖлᱻÓõ½µÄÒ»¸ö½Å±¾£¬ÆäÖаüº¬Ò»Ð©¸ñʽ»¯
Êä³öµÄsetÃüÁî
£¬ÎªÁË·½±ãÀí½â£¬ÎÒ»áÔÚÿһÌõsetÃüÁîÖ®ºó½ô¸ú×ÅÒ»¸ö¼òµ¥µÄ½âÊÍ£¬ÇëÂýÂýÌå»á¡£
sqlplus -s user_name/user_password << EOF >/dev/n ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[pr_xls_to_tb]
@path varchar(200),--EXCEL·¾¶Ãû
@tbName varchar(30),--±íÃû
@stName varchar(30) --excelÖÐÒª¶ÁµÄSHEETÃû
as
declare @sql varchar(500),--×îºóÒªÖ´ÐеÄSQL
@stName_Real varchar(35),--ÕæÕýµÄSHEETÃû
......