Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔÊÔ¿´.²»ÖªÕâ¸öÎÊÌâÔõô½â¾ö?
ÄãÊÇÔõÑùÕ³Ìû²Ù×÷µÄѽ¡£

Äã°ÑÕâ¸öÊý¾Ý¿½±´µ½ÆÕͨµÄÎı¾ÀÓÐûÓÐÕâ¸öÎÊÌâѽ¡£

ÎÒÖ±½Ó°ÑÄãÕâÀïµÄÊý¾Ý¿½µ½plsql devÀïûÓÐÎÊÌâµÄѽ¡£

±íÖеÄÊý¾Ý¸ñʽÊÇʱ¼ä¸ñʽ¾Í»áÏû³ýË«ÒýºÅ°É
Äã°Ñ¸ñʽ¸ÄÏÂ

ÄãÏëÒªÔÚÊý¾Ý¿âÀï³ÊÏÖ
"2009-01","8949-232"
ÕâÑùµÄÊý¾Ý?
Òª²åÈë"ÌØÊâ·ûºÅ
Ó¦¸ÃÔÚÍâ²ãÔÙ¼Ó¸ö'
ÀýÈç:
seLECT '"8949-232"' from DUAL;
ÏÔʾ"8949-232"

up

²»´íµÄÌù

ÊÇÎÒÎÊÌâûÓвûÊöÇå³þ,ÎÒÊǽ«EXCELÖеÄÖµÕ³µ½PLSQL DeveloperÀï,³öÏÖEXCELÖк¬ÓÐË«ÒýºÅµÄÖµ¶ªÊ§ÓÖÒýºÅ,×îºó½«PLSQL DeveloperÉý¼¶µ½×îа汾¾ÍûÎÊÌâÁË.

½áÌù,лл¥ÉÏÈÊÐֵĻشð.


Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

SQL ¹ØÓÚ¶àÌõupdate

ÀýÈçÓÐ2¸ö±í Ò»¸öÊÇÔ±¹¤ÐÅÏ¢±í ±íÀïÓÐÃû×Ö ¹¤×ʵÈ×Ö¶Î Ò»¸öÊǹ«Ë¾²ÆÎñ±íÓРÿÔÂ×ÜÖ§³öµÈ×Ö¶Î

ÏÖÔÚÒª¸øÒ»¸öÔ±¹¤Õǹ¤×Ê 500RMB  ¾ÍҪд2Ìõ UPDATEÓï¾ä£¨¼ÙÉèÖ»ÓÐÁ½ÕÅ±í¡£Êµ¼Ê¿Ï¶¨Òª¸ü¶à£©

ÎÊ£ºÈçºÎ ......

sql server 2005 µÄÖØÐ°²×°ÎÊÌâ

ÖØÐ°²×°sql server 2005ʱ£¬ÔÚ°²×°µ½ÀàËÆdata base service µÄ·þÎñʱ×ÜÊdzöÏîwindows installer µÄ´íÎó¡£
ÎÒÔÚÍøÉϲéÁ˽â¾öµÄ°ì·¨£¬ÏÈÍ£ÁËÕâ¸ö·þÎñ£¬È»ºóÖØÐÂÏÂÔØ°²×°ÁËInstMsiW.exe£¬È»ºóÓÖÆô¶¯Õâ¸ö·þÎñ£¬µ«ÊDz ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ