ʵÏÖ¶àÐкϲ¢Ò»ÐеÄSQLд·¨
[ORACLE]
ÏîÄ¿ÖÐÓöµ½Ò»¸öÐèÇó£¬ÐèÒª½«¶àÐкϲ¢ÎªÒ»ÐС£
±í½á¹¹ÈçÏ£º
NAME Null Type
------------------------ --------- -----
N_SEC_CODE NOT NULL CHAR(6)
C_RESEARCHER_CODE NOT NULL VARCHAR2(20)
´Ë±í±£´æÁË“¹ÉƱ”Óë“Ñо¿Ô±”µÄ¶ÔÓ¦¹ØϵÊý¾Ý£¬Ò»°ã¶øÑÔ£¬¶ÔÓÚͬһֻ¹ÉƱ¶øÑÔ£¬¿ÉÄÜÓжà¸öÑо¿Ô±
¶ÔÆä½øÐиú×ÙÑо¿¡£ËùÒÔÄ¿Ç°Óöµ½Ò»¸öÒªÇó£¬Ðè²éѯ³öÿֻ¹ÉƱºÍ¶ÔÓ¦µÄÑо¿Ô±£¨Ñо¿Ô±´úÂë¼ä£¬Ê¹ÓöººÅ·Ö¸ô£©¡£
ÀýÈçÓÐÈçÏÂÊý¾Ý£º
000297 chenpeng
000297 liusu
ºÏ²¢´¦ÀíºóÐèÏÔʾΪ£º
000297 chenpeng,liusu
ÍøÉϲéÁ˺ܶ෽·¨£¬µ«Í¨³£¶øÑÔ¶¼ÊDZàд×Ô¶¨Òå¶àÐÐÎı¾ºÏ²¢º¯Êý£¬»òÕ߶ÔÖ§³ÖµÄÁÐÊý¾ßÓоÖÏÞÐÔ¡£
×îºóÔÚÓ¢ÎÄgoogleÖÐËѵ½ÈçϱȽÏÇɵķ½·¨¡£²»ÓÃÔÚÊý¾Ý¿âÖÐÔö¼Ófunction£¬´¿SQLÒ»´ÎÐԸ㶨£¬
¶øÇÒÀ©³äÐԺܺã¬Ã»ÓÐÁеÄÏÞÖÆ¡£
Ö÷ÒªSQLÈçÏ£º
SELECT n_sec_code, TRANSLATE (LTRIM (text, '/'), '*/', '*,') rese
Ïà¹ØÎĵµ£º
ʹÓÃPowerDesignerÉú³ÉÊý¾Ý¿â
½¨±íSQL
½Å
±¾Ê±£¬ÓÈÆäÊÇOracleÊý¾Ý¿âʱ£¬±íÃûÒ»°ã»á´øÒýºÅ¡£Æäʵ¼ÓÒýºÅÊÇPL/SQLµÄ¹æ·¶£¬Êý¾Ý¿â»áÑϸñ°´ÕÕ“”ÖеÄÃû³Æ½¨±í£¬Èç¹ûûÓГ”£¬»á°´ÕÕ
ORACLEĬÈϵÄÉèÖý¨±í£¨DBA
STUDIOÀïÃ棩£¬Ä¬ÈÏÊÇÈ«²¿´óд£¬ÕâÑù£¬ÔÚORACLEÊý¾Ý¿âÀïµÄ×ֶξÍÈç“Column_1&rdqu ......
SELECT
(case when a.colorder=1 then d.name
--+'('+cast(h.value as nvarchar)+')'
else '' end)±íÃû,
a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
isnull(g.[value],'') AS ×Ö¶Î˵Ã÷,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '¡Ì'else '' end) ±êʶ,
(case whe ......
1.SQL Server Mobile ¼ò½é
2.»ñÈ¡ SQL Server Mobile
3.°²×°±Ø±¸Èí¼þ
4.°²×°¿ª·¢»·¾³
5.°²×°·þÎñÆ÷»·¾³
6.ÅäÖà Web ͬ²½Ïòµ¼
7.ʹÓà Internet Explorer ¼ì²é SQL Server Mobile ·þÎñÆ÷´úÀíÅäÖÃ
8.ʹÓÃSQL Server Mobile Êý¾Ý¿â
==========================
1.SQL Server Mobile ¼ò½é
-------------------------- ......
½¨Á¢Ò»¸ö Web Ó¦Ó㬷ÖÒ³ä¯ÀÀ¹¦Äܱز»¿ÉÉÙ¡£Õâ¸öÎÊÌâÊÇÊý¾Ý¿â´¦ÀíÖÐÊ®·Ö³£¼ûµÄÎÊÌâ¡£¾µäµÄÊý¾Ý·ÖÒ³·½·¨ÊÇ:ADO ¼Í¼¼¯·ÖÒ³·¨£¬Ò²¾ÍÊÇÀûÓÃADO×Ô´øµÄ·ÖÒ³¹¦ÄÜ£¨ÀûÓÃÓα꣩À´ÊµÏÖ·ÖÒ³¡£µ«ÕâÖÖ·ÖÒ³·½·¨½öÊÊÓÃÓÚ½ÏСÊý¾ÝÁ¿µÄÇéÐΣ¬ÒòΪÓα걾ÉíÓÐȱµã£ºÓαêÊÇ´æ·ÅÔÚÄÚ´æÖУ¬ºÜ·ÑÄÚ´æ¡£ÓαêÒ»½¨Á¢£¬¾Í½«Ïà¹ØµÄ¼Ç¼Ëøס£¬Ö±µ½È¡ÏûÓ ......