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

ÇóÒ»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(FDetailID FCount F2 F8 F2033)ÁÐÊý²»È·¶¨£¿


ÊÇ£¬ÁÐÊý²»È·¶¨£¬¶øÇÒµÚÈýÁпªÊ¼Ã¿¸öÁж¼¿ÉÄÜÓÐÖµ£¬µ«Öµ¿Ï¶¨²»Ïàͬ


ÕýÈ·À´Ëµ£¬T2µÄÁлáÓÐÔö¼Ó£¬µ«¿Ï¶¨²»»á¼õÉÙ

°ï¶¥ ...


htl258£¬ÄãÕâ¸öÖ»Õë¶ÔF8ºÍF2033Âð£¬Êµ¼ÊÉÏF×£¬Õâ¸ö×Ô¤ÏȲ»ÖªµÀµÄŶ

Ö»Äܸù¾Ý16 ºÍ 207 È·¶¨ÊÇF8

²»µÈÁË£¬»»Ò»ÖÖ·½·¨

WRTERYTRBYU

²»ÖªµÀÔõô×ö¡£¡£¡£


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

sqlÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ