MS SQL Server ¼¸¸öϵͳ±í½éÉÜ
1.±íSYSOBJECTSÓÃÓÚÃèÊöÊý¾Ý¿âÖеĶÔÏó --±í¡¢ÊÓͼ¡¢´æ´¢¹ý³ÌµÈ
˵Ã÷£º¸Ã±íÏà¹Ø×ֶεĺ¬ÒåÈçÏ£º
¡¡¡¡SYSOBJECTS.name ¶ÔÏóÃû£¬È磺±íÃû£¬ÊÓͼÃû¡£
¡¡¡¡SYSOBJECTS.id ¶ÔÏóid¡£
¡¡¡¡SYSOBJECTS.type ¶ÔÏóÀàÐÍ£¨p´æ´¢¹ý³Ì£¬vÊÓͼ£¬sϵͳ±í£¬uÓû§±í£©¡£
ex:
SELECT * from Sysobjects WHERE NAME='GetRegularVal'
SELECT * from Sysobjects WHERE xtype='V'
À©Õ¹£º Èç¹ûÐèÒª ²éѯËùÓÐÊÓͼ £¬³ýÁË SELECT * from Sysobjects WHERE xtype='V' Äܲéѯµ½Í⣬»¹¿ÉÒÔÓãº
SELECT * from sys.VIEWS¡£sys.VIEWS ÊÇ¶Ô ÊÓͼµÄÒ»¸ö·â×°
2.±íSYSCOLUMNS Ϊÿ¸ö±í¡¢ÊÓͼÖеÄÿ¸öÁкÍÿ¸ö´æ´¢¹ý³ÌµÄÿ¸ö²ÎÊý´´½¨Ò»Ìõ¼Ç¼
¸Ã±íÏà¹Ø×ֶεĺ¬ÒåÈçÏ£º£¨´Ë´¦µÄÁÐϵָÊý¾Ý¿âÖÐÿ¸ö±í¡¢ÊÓͼÖеÄÁУ©
¡¡¡¡SYSCOLUMNS. id ¸ÃÁÐËùÊôµÄ±íµÄid£¬¿ÉÓëSYSOBJECTS.idÏà¹ØÁª
¡¡¡¡SYSCOLUMNS.colid ÁÐid£¬±íʾ¸ÃÁÐÊDZí»òÊÓͼµÄµÚ¼¸ÁС£
¡¡¡¡SYSCOLUMNS.type ÎïÀí´æ´¢ÀàÐÍ£¬¿ÉÓëSYSTYPES.typeÏà¹ØÁª¡£
¡¡¡¡SYSCOLUMNS.length Êý¾ÝµÄÎïÀí³¤¶È¡£
¡¡¡¡SYSCOLUMNS.name ÁÐÃû×Ö£¬¼´×Ö¶ÎÃû¡£
¡¡¡¡SYSCOLUMNS .Pre Áеľ«¶È¼¶¡£
¡¡¡¡SYSCOLUMNS .Scale Áеıê¶È¼¶
ex:
SELECT * from syscolumns WHERE ID=OBJECT_ID('ECORDER')
±¾¾äµÈ¼Û£º
SELECT * from syscolumns WHERE ID IN (SELECT ID from sysObjects WHERE NAME='ECORDER')
3.±íSYSTYPES Ϊÿ¸öϵͳºÍÿ¸öÓû§ÌṩµÄÊý¾ÝÀàÐÍ´´½¨Ò»Ìõ¼Ç¼£¬Èç¹ûËüÃÇ´æÔÚ£¬¸ø¶¨ÓòºÍĬÈÏÖµ£¬ÃèÊöϵͳÌṩµÄÊý¾ÝÀàÐ͵ÄÐв»¿É¸ü¸Ä¡£
¡¡¡¡¸Ã±íÏà¹Ø×ֶεĺ¬ÒåÈçÏ£º
¡¡¡¡SYSTYPES.name Êý¾ÝÀàÐ͵ÄÃû×Ö¡£
¡¡¡¡SYSTYPES.type ÎïÀí´æ´¢Êý¾ÝÀàÐÍ
Ïà¹ØÎĵµ£º
ORACLE SQLÐÔÄÜÓÅ»¯
ÎÒÒª½²µÄÌâÄ¿ÊÇOracle SQLÐÔÄÜÓÅ»¯£¬Ö»ÊÇOracleÐÔÄÜÓÅ»¯ÖеÄÒ»Ïî¡£OracleµÄÐÔÄÜÓÅ»¯°üº¬ºÜ¶à·½Ã棬±ÈÈçµ÷ÕûÎïÀí´æÈ¡£¬µ÷ÕûÂß¼´æÈ¡£¬µ÷ÕûÄÚ´æʹÓ㬼õÉÙÍøÂçÁ÷Á¿µÈ¡£ÕâÀïÑ¡ÔñSQLÐÔÄÜÓÅ»¯ÊÇÒòΪÕⲿ·ÖÄÚÈÝÎÒÃDzâÊÔÈËÔ±×îÈÝÒ×½Ó´¥µ½£¬ÁíÍ⿪·¢ÈËԱдSQL½Å±¾Ê±ÓÐʱºÜËæÒ⣬²»Öª²»¾õ¾Í»áÔì³É³ÌÐòÐÔÄÜÉϵÄÏ ......
¸øPL/SQL´´½¨Õ˺š¢ÃÜÂëºÍ¸¶È¨ÏÞ
CREATE USER zxd PROFILE "DEFAULT" IDENTIFIED BY zxd DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
grant dba to "zxd";
F:\oracle\ora92\network\admin ·¾¶ÏÂtnsnames.ora
ZXD =
(DESCRIPTION =
&nb ......
PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔÒò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øʹÓá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍ ......
Çë°´²½Öè½øÐУ¬Î´½øÐÐÇ°ÃæµÄ²½Öèʱ£¬Çë²»Òª×öºóÃæµÄ²½Ö裬ÒÔÃâËð»µÄãµÄÊý¾Ý¿â¡£
Ò»°ã²»½¨Òé×öµÚ4£¬6Á½²½£¬µÚ4²½²»°²È«£¬ÓпÉÄÜËð»µÊý¾Ý¿â»ò¶ªÊ§Êý¾Ý¡£µÚ6²½Èç¹ûÈÕÖ¾´ïµ½ÉÏÏÞ£¬ÔòÒÔºóµÄÊý¾Ý¿â´¦Àí»áʧ°Ü£¬ÔÚÇåÀíÈÕÖ¾ºó²ÅÄָܻ´¡£
1¡¢Çå¿ÕÈÕÖ¾
DUMP TRANSACTION ¿âÃû WITH NO_LOG
2¡¢½Ø¶ÏÊÂÎñÈÕÖ¾
B ......
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄǾÍÐèҪѡÔñ½»²æ±í(interse ......