Êý¾Ý¿âÊÔ¾í¼°´ð°¸ ÏÂÔØ±¾ÎÄ

ÖµExecsp _ Rename V _ Court¡£Ðº½ÏßÈý¡£²Ù×÷ÎÊÌâ1. (1)½¨Á¢Èý¸öÊý¾Ý¿âÏúÊÛ±í:¿Í»§¡¢²úÆ·ºÍÏúÊÛ±í ÍøÂçÊý¾Ý¿âÊÔ¾íµÚ15Ò³£¬¹²17Ò³ Ò³(Ö¤Ã÷)

Ò³(2)¿Í»§±íÖ÷¼ü(CusNo)

²úÆ·±íÖ÷¼ü(²úÆ·)ÊÇ:²úÆ·ºÅ(ProNo)

ÏúÊÛ±íÖ÷¼ü(Ö¤Ã÷)ÊÇ:ÏúÊÛÈÕÆÚ¡¢¿Í»§ºÅ ²úÆ·±àºÅ(ProNo) (3)´´½¨Ë÷ÒýIX _¿Í»§¶Ô¿Í»§(¿Í»§Ãû³Æ) ´´½¨Î¨Ò»Ë÷ÒýIX _²úÆ·¶Ô²úÆ·(ProName) ´´½¨Î¨Ò»¾Û¼¯Ë÷ÒýIX _Ö¤Ã÷¶ÔÖ¤Ã÷(ÏúÊÛÈÕÆÚ) (4)ʹÓÃÏúÊÛ Ö´ÐÐ ¸ü¸Ä±íÖ¤Ã÷

Ìí¼ÓÔ¼ÊøFK_Ö¤Ã÷_ ProOut_ProNoÍâ¼ü(ProNo ¡°ÊýÁ¿¡± (6)´ÓProOut×éÖÐÑ¡ÔñProNo °´ProNo

£¬ÇóºÍ(ÊýÁ¿)> 100

(7)´´½¨º¯ÊýÕÙ»½Ê÷(@x Decimal£¬@ yde cial) return secial as begin return(@ x * @ y)endgo-test

Ñ¡Ôñpo.prono£¬proname£¬dbo¡£ ¿Í»§±àºÅΪC

£¬ÆäÖÐÆÕÆÕÂÞŵ=¡®P0002 ¡®ºÍÆÕ¿â˹ŵ=¿Í»§¶©¹ººÅÓÉ¿â˹ÄÉdesc

ÍøÂçÊý¾Ý¿â¿¼ÊÔÎÊÌâµÚ16Ò³(¹²17Ò³) (9)Ñ¡Ôñ¿â˹ŵ£¬×ÜÊý(ÊýÁ¿) ´ÓÖ¤Ã÷

£¬ÆäÖпâ˹ŵ= ¡®C004 ¡®ºÍÏúÊÛÈÕÆÚ> ¡® 2007-12-31¡¯ 256 °´²É¹º¶©µ¥·Ö×é¡£ProNo£¬¼Û¸ñ

(11)CREATE PROCEDURE p _ Pro @ CusNo VARCHAR(8) AS

Ñ¡ÔñCuSno£¬ProNo£¬×ܺÍ(ÊýÁ¿) from ProOut

ÆäÖÐCusNo =@ CusNo group by CusNo£¬ProNO

(12) ¸üÐÂΪ

¸üвúÆ·¼¯¿â´æ=¿â´æ-ÊýÁ¿£¬ÆäÖÐProNo=(´Ó²åÈëÖÐÑ¡ÔñProNO) ¸üвúÆ·¼¯¿â´æ=¿â´æ+ÊýÁ¿£¬ÆäÖÐProno =(´Óɾ³ýÖÐÑ¡ÔñProNO) (13)·½·¨1:ʹÓÃÆóÒµ¹ÜÀíÆ÷

Ñ¡ÔñÊý¾Ý¿âÏúÊÛ£¬ÓÒ¼üµ¥»÷£¬Ñ¡Ôñ¡°ËùÓÐÈÎÎñ¡±×Ӳ˵¥£¬È»ºóµ¥»÷¡°±¸·ÝÊý¾Ý¿â¡±ÃüÁ²¢ÔÚ¡°±¸·Ý¡±Ñ¡ÏîÖÐÑ¡Ôñ¡°Êý¾Ý¿â-Íê³É¡±

ÍøÂçÊý¾Ý¿âÊÔÌâµÚ17Ò³(¹²17Ò³)