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Êý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÀýÈçÓÐ2¸ö±í Ò»¸öÊÇÔ±¹¤ÐÅÏ¢±í ±íÀïÓÐÃû×Ö ¹¤×ʵÈ×Ö¶Î Ò»¸öÊǹ«Ë¾²ÆÎñ±íÓРÿÔÂ×ÜÖ§³öµÈ×Ö¶Î
ÏÖÔÚÒª¸øÒ»¸öÔ±¹¤Õǹ¤×Ê 500RMB ¾ÍҪд2Ìõ UPDATEÓï¾ä£¨¼ÙÉèÖ»ÓÐÁ½ÕÅ±í¡£Êµ¼Ê¿Ï¶¨Òª¸ü¶à£©
ÎÊ£ºÈçºÎ ......
ÖØÐ°²×°sql server 2005ʱ£¬ÔÚ°²×°µ½ÀàËÆdata base service µÄ·þÎñʱ×ÜÊdzöÏîwindows installer µÄ´íÎó¡£
ÎÒÔÚÍøÉϲéÁ˽â¾öµÄ°ì·¨£¬ÏÈÍ£ÁËÕâ¸ö·þÎñ£¬È»ºóÖØÐÂÏÂÔØ°²×°ÁËInstMsiW.exe£¬È»ºóÓÖÆô¶¯Õâ¸ö·þÎñ£¬µ«ÊDz ......