Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

OracleÖÐSQL±àд¼¯½õ

1¡¢ÊµÏÖÐÐÁж¯Ì¬×ª»»£¬³£ÓÃÓÚÖ÷´Ó±í¹ØÁªÊ±µÄÌØÊâÐèÇó
select rwbm,psqh,
           max(decode(xh1,1,yy))JKYL1,
           max(decode(xh1,2,yy))JKYL2,
        &n ......

ÔõÑù½«oracleÖÐµÄ±íµ¼Èësql server

1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷Éϰ²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ͨ¹ýoracle¿Í»§¶Ë£¬ÔÚnetmanagerÖн¨Á¢“·þÎñ£¨TNS server£©”£¬²¢²âÊÔÁ¬½ÓÉÏoracleÊý¾Ý¿âÕý³£
2¡¢ÔÚsqlserverµÄDTS(µ¼ÈëºÍµ¼³öÊý¾Ý¹¤¾ß)½øÐÐ
£¨1£©Ñ¡ÔñÊý¾ÝÔ´£º
Êý¾ÝÔ´£ºoracle in oracle9i
Ñ¡Ôñ£ºÓû§/ϵͳDSN:
µã»÷н¨ ......

Ó°ÏìSQL serverÐÔÄܵĹؼüÈý¸ö·½Ãæ

1 Âß¼­Êý¾Ý¿âºÍ±íµÄÉè¼Æ
Êý¾Ý¿âµÄÂß¼­Éè¼Æ¡¢°üÀ¨±íÓë±íÖ®¼äµÄ¹ØÏµÊÇÓÅ»¯¹ØÏµÐÍÊý¾Ý¿âÐÔÄܵĺËÐÄ¡£Ò»¸öºÃµÄÂß¼­Êý¾Ý¿âÉè¼Æ¿ÉÒÔΪ
ÓÅ»¯Êý¾Ý¿âºÍÓ¦ÓóÌÐò´òÏÂÁ¼ºÃµÄ»ù´¡¡£
±ê×¼»¯µÄÊý¾Ý¿âÂß¼­Éè¼Æ°üÀ¨ÓöàµÄ¡¢ÓÐÏ໥¹ØÏµµÄÕ­±íÀ´´úÌæºÜ¶àÁеij¤Êý¾Ý±í¡£ÏÂÃæÊÇһЩʹÓñê×¼»¯
±íµÄһЩºÃ´¦¡£
A:ÓÉÓÚ±íÕ­£¬Òò´Ë¿ÉÒÔʹŠ......

sql server Êý¾Ý¿âµ¼ÈëÎÊÌâ

ÓÉÓÚÍøÕ¾ÊDZðÈ˵Ä
sql server  2000 ²»Äܵ¼Èë2005 µÄÊý¾Ý¿âÎļþ ÎÒÖ»ºÃ°´ÕÕÊéÉÏÖØÐ½¨Á¢µÄÊý¾Ý¿âÎļþ
È»ºóÔÚvisual studio 2005ÖÐÒ»¸öÒ»¸öµÄ¸´ÖÆ´æ´¢¹ý³Ìµ½sql server 2000
ÕâÑù¾Í²»ÓÃÏÂÔØ sql server 2005 ÁË
Èç¹ûÓÐsql server 2005 µÄ»°Ö®¼ÊÉú³É ½Å±¾¾ÍÒ»ÖÂÐÔµ¼Èë¾ÍokÁË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ