ÇóÒ»SQLÓï¾ä - MS-SQL Server / »ù´¡Àà
T1:£¨FID +FEntryID Ψһ£©
FID FEntryID FDetailID
11 1 16
11 2 20
T2:£¨FDetailID Ψһ£©
FDetailID FCount F2 F8 F2033
16 0 0 207 0
20 1 0 0 517
T3:£¨FInterId +FClassID Ψһ£©
FInterId FClassID FNumber
207 8 ABC
207 11 EEE
517 2033 UUU
ÒªÇó½á¹û
FID FEntryID FDetailID FClassID FNumber
11 1 16 8 ABC
11 2 20 2033 UUU
½á¹ûÖÐFClassID¾ÍÈ¡T2µÄ´ÓµÚ2ÁпªÊ¼ÁÐÃûµÄÊý×Ö£¨³ýÈ¥ÆäÖеÄF£¬µ«²»Ò»¶¨µÚËÄÁоÍÊÇF8£¬µ«Êý×ֿ϶¨ÊÇÓÐСµ½´ó£©£¬FNumberÈ¡ÔÚT3ÖÐFInterId£¬ FClassID£¨ÈçFInterId=207£¬FClassID =8µÄÖµÊÇABC£©·ûºÏÌõ¼þµÄFNumberÖµ¡£
·¢ÌûʱºÍ·¢ÌûºóЧ¹ûÓÐÆ«²î£¬±íÁкÍֵû¶ÔÆë£¬´ó¼ÒÄÜ·ÖµÄÇå³þÂð
T2(FDetailID FCount F2 F8 F2033)ÁÐÊý²»È·¶¨£¿
ÊÇ£¬ÁÐÊý²»È·¶¨£¬¶øÇÒµÚÈýÁпªÊ¼Ã¿¸öÁж¼¿ÉÄÜÓÐÖµ£¬µ«Öµ¿Ï¶¨²»Ïàͬ
ÕýÈ·À´Ëµ£¬T2µÄÁлáÓÐÔö¼Ó£¬µ«¿Ï¶¨²»»á¼õÉÙ
°ï¶¥ ...
htl258£¬ÄãÕâ¸öÖ»Õë¶ÔF8ºÍF2033Âð£¬Êµ¼ÊÉÏF×£¬Õâ¸ö×Ô¤ÏȲ»ÖªµÀµÄŶ
Ö»Äܸù¾Ý16 ºÍ 207 È·¶¨ÊÇF8
²»µÈÁË£¬»»Ò»ÖÖ·½·¨
WRTERYTRBYU
²»ÖªµÀÔõô×ö¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡
¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡
Ö±½ÓÖ´ÐоÍÐÐÁË
exec ......