¼¸¸ö³£Óõģ¬¶Ô±íµÄ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¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷Éϰ²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ͨ¹ýoracle¿Í»§¶Ë£¬ÔÚnetmanagerÖн¨Á¢“·þÎñ£¨TNS server£©”£¬²¢²âÊÔÁ¬½ÓÉÏoracleÊý¾Ý¿âÕý³£
2¡¢ÔÚsqlserverµÄDTS(µ¼ÈëºÍµ¼³öÊý¾Ý¹¤¾ß)½øÐÐ
£¨1£©Ñ¡ÔñÊý¾ÝÔ´£º
Êý¾ÝÔ´£ºoracle in oracle9i
Ñ¡Ôñ£ºÓû§/ϵͳDSN:
µã»÷н¨ ......
º¯Êý¼ò½é:¡¡¡¡
·µ»Ø Variant (Long) µÄÖµ£¬±íʾÁ½¸öÖ¸¶¨ÈÕÆÚ¼äµÄʱ¼ä¼ä¸ôÊýÄ¿¡£
º¯ÊýÓï·¨:
¡¡¡¡DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
DateDiff º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÀ´¼ÆËãdate1 ºÍ date2 µÄʱ¼ä²îµÄʱ¼ä¼ ......
USE [master]
GO
ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE
GO
USE [Database_Name]
&nb ......
-- Sql Get Last Day of Month...
SELECT (CASE MONTH(GETDATE())
WHEN 1 THEN 31
&nbs ......