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

¼¸¸ö³£Óõģ¬¶Ô±íµÄijһÁнøÐвÙ×÷µÄSQLÃüÁî

ÊÊÓãºORACLE
 ÐÞ¸ÄÁÐÃû
          alter table xxx rename column aaa to bbb;
ɾ³ýÒ»ÁÐ
          alter table xxx drop column aaa;
Ôö¼ÓÒ»ÁÐ
          alter table xxx add aaa varchar2(22);
ÐÞ¸ÄijÁеÄÀàÐÍ
           alter table xxx modify aaa varchar2(22);
°ÑijһÁеÄÖµ¸³¸øÁíÒ»ÁÐ
           update xxx set aaa = bbb;
ÐÞ¸ÄijһÁÐÔÊÐíΪ¿Õ£¨²»Îª¿Õ£©
           alter table xxx modify aaa (not) null;
ÐÞ¸ÄijһÁеÄĬÈÏÖµ
           alter table xxx modify aaa default 1;
ΪijһÁÐÔö¼Ó×¢ÊÍ
           comment on column xxx.aaa  is 'abc......';
ÉèÖÃijһÁÐΪÖ÷¼ü
           alter table xxx add constraint PK_XXX primary key (aaa);
ɾ³ýÖ÷¼ü
           alter table xxx drop constraint PK_XXX cascade;
Ôö¼Ó£¨Î¨Ò»£©Ë÷Òý
           create (unique) index IDX_XXX_AAA on xxx(aaa);
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØ×Ô£ºhttp://blog.csdn.net/alex197963/archive/2007/04/29/1591439.aspx


Ïà¹ØÎĵµ£º

ÇÉÓÃSQLµÄÈ«¾ÖÁÙʱ±í·ÀÖ¹Óû§Öظ´µÇ¼

ÇÉÓÃSQLµÄÈ«¾ÖÁÙʱ±í·ÀÖ¹Óû§Öظ´µÇ¼
ÎÄÕÂÀ´×Ô£ºhttp://www.cnblogs.com/lindayyh/archive/2010/04/05/1704763.html
ÔÚÎÒÃÇ¿ª·¢ÉÌÎñÈí¼þµÄʱºò£¬³£³£»áÓöµ½ÕâÑùµÄÒ»¸öÎÊÌ⣺ÔõÑù·ÀÖ¹Óû§Öظ´µÇ¼ÎÒÃǵÄϵͳ£¿ÌرðÊǶÔÓÚÒøÐлòÊDzÆÎñ²¿ÃÅ£¬¸üÊÇÒªÏÞÖÆÓû§ÒÔÆä¹¤ºÅÉí·Ý¶à´ÎµÇÈë¡£
¿ÉÄÜ»áÓÐÈË˵ÔÚÓû§ÐÅÏ¢±íÖмÓÒ»×Ö¶ÎÅÐ ......

SQLÓï¾äÖÐDateAdd º¯Êý˵Ã÷

·µ»Ø 
¡¡¡¡·µ»Ø°üº¬Ò»¸öÈÕÆÚµÄ Variant (Date)£¬ÕâÒ»ÈÕÆÚ»¹¼ÓÉÏÁËÒ»¶Îʱ¼ä¼ä¸ô¡£
Óï·¨
¡¡¡¡DateAdd(interval, number, date)
¡¡¡¡DateAdd º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬ÊÇËùÒª¼ÓÉÏÈ¥µÄʱ¼ä¼ä¸ô¡£
¡¡¡¡number ±ØÒª¡£ÊýÖµ±í´ïʽ£¬ÊÇÒª¼ÓÉϵÄʱ¼ä¼ä¸ôµÄÊýÄ¿¡£ÆäÊýÖµ¿ÉÒÔΪÕýÊý£¨µÃ ......

Oracle SQLÓÅ»¯¼¼ÇÉ

ÎÒ¾õµÃÖ÷ÒªÓ¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
ÏÖÔÚ¼òµ¥µÄ¾Ù¼¸¸öÀý×Ó
Where×Ó¾äÖÐÓГ!=”½«²»Ê¹ÓÃË÷Òý
select account_name from test where amount != 0  (²»Ê¹ÓÃ) ......

sql server 2005 ѧϰ±Ê¼Ç

µÚÒ»Õ£ºÐÅÏ¢Ìåϵ½á¹¹Ô­Ôò
¸ù¾ÝÒÔÏÂ7¸öÏ໥ÒÀÀµµÄÊý¾Ý´æ´¢Ä¿±êÉè¼ÆºÍÆÀ¹ÀÈκÎÊý¾Ý´æ´¢£º
l  ¼òµ¥ÐÔ£»
l  ÓÐÓÃÐÔ
l  Êý¾ÝÍêÕûÐÔ
l  ÐÔÄÜ
l  ¿ÉÓÃÐÔ
l  ¿ÉÀ©Õ¹ÐÔ
l  °²È«ÐÔ
 
¼Ü¹¹Éè¼ÆÔ­Ôò
l  ±ÜÃâ¹ýÓÚ¸´ÔÓ
l  ¾«ÐÄÌôÑ¡¼ü
l  Ê÷Á¢¿ÉÑ¡Êý¾Ý
l  ÊµÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ