¼¸¸ö³£Óõģ¬¶Ô±íµÄ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
Ïà¹ØÎĵµ£º
1¡¢ÊµÏÖÐÐÁж¯Ì¬×ª»»£¬³£ÓÃÓÚÖ÷´Ó±í¹ØÁªÊ±µÄÌØÊâÐèÇó
select rwbm,psqh,
max(decode(xh1,1,yy))JKYL1,
max(decode(xh1,2,yy))JKYL2,
&n ......
1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ͨ¹ýoracle¿Í»§¶Ë£¬ÔÚnetmanagerÖн¨Á¢“·þÎñ£¨TNS server£©”£¬²¢²âÊÔÁ¬½ÓÉÏoracleÊý¾Ý¿âÕý³£
2¡¢ÔÚsqlserverµÄDTS(µ¼ÈëºÍµ¼³öÊý¾Ý¹¤¾ß)½øÐÐ
£¨1£©Ñ¡ÔñÊý¾ÝÔ´£º
Êý¾ÝÔ´£ºoracle in oracle9i
Ñ¡Ôñ£ºÓû§/ϵͳDSN:
µã»÷н¨ ......
SELECT DISTINCT '['+user_name(b.uid)+'].['+b.name+']' AS ¶ÔÏóÃû,b.type AS ÀàÐÍ
from sysdepends a,sysobjects b
WHERE b.id=a.depid
AND a.id=OBJECT_ID('¹ý³ÌÃû');
EXEC SP_DEPENDS '¹ý³ÌÃû';
......
ÎÊÌâ:
Äú¹¤×÷µÄ±¾»ú×°ÓÐVisual Studio 2005£¬¾ÖÓòÍøÖÐÓÐһ̨SQL Server 2005Êý¾Ý¿â·þÎñÆ÷£¬ÄãÏëͨ¹ý±¾»úÔ¶³Ìµ÷ÊÔSQL Server 2005·þÎñÆ÷ÉϵĴ洢¹ý³Ì¡£µ«ÊDz»ÖªµÀÈçºÎÅäÖûòÆôÓÃÔ¶³Ìµ÷ÊÔ£¿Ï£ÍûÕâƪÎÄÕ¶ÔÄúÓÐÓ᣶ÔÓÚÊý¾Ý¿âºÍVisual StudioÔÚͬһ»úÆ÷µÄ´æ´¢¹ý³Ìµ÷ÊÔ£¬Ô°×ÓÀïÒѾÓÐһƪÒë×÷˵µÄºÜºÃÁË£¬¿ ......