Sql 2005 ±¨´í£¿£¿£¿ - MS-SQL Server / »ù´¡Àà
ÎÒÔÚsql 2005ÖÐдһ¸ö¼òµ¥µÄÁ¬½Ó¶¼±¨´í £º
È磺select * from a_AppHeader b left join a_BillHeader a on b.cReportNo = a.vReportNo
±¨´íΪ£º¡°¾¯¸æ: ÔÚ 04 26 2010 8:50AM ³öÏÖ´íÎó 9100¡£Çë¼Ç¼¸Ã´íÎóºÍʱ¼ä£¬²¢ÓëÄúµÄϵͳ¹ÜÀíÔ±ÁªÏµ¡±
ÇëÎÊʲôÔÒò¡£¡£
±íÔÚÊý¾Ý¿âÖÐÊÇ´æÔÚµÄ...
½¨ÒéÐÞ¸´Ò»ÏÂÊý¾Ý¿â
select * from dbo.a_AppHeader b left join dbo.a_BillHeader a on b.cReportNo = a.vReportNo
°Ñ±íµÄËùÓÐÕß´øÉÏÔÙÊÔÊÔ.
SQL code:
select * from sysobjects where name='a_AppHeader'
ÏȲéһϿ´ÔÚϵͳÖÐÊÇ·ñȷʵ´æÔÚ¡£Èç¹û´æÔÚ£¬¼Ó¸ödbo£¨ÄãµÄʵ¼Ê¼Ü¹¹Ãû£©ÊÔÊÔ¡£ÔÙ²»ÐйÀ¼Æ¾ÍÖ»ÓÐÐÞ¿âÁË¡£
´øÉÏÊý¾Ý¿âËùÓÐÕß ÈçÏ£º
select * from TTS.dbo.a_AppHeader b left join TTS.dbo.a_BillHeader a on b.cReportNo = a.vReportNo
»¹ÊDZ¨Ò»ÑùµÄ´íÎ󡣡£
ÕâÊý¾Ý¿â¿ªÊ¼ÊÇÓÃsql 2000,×òÌìÓû§°ÑËûתµ½ sql 2005.
ÄÇÔÙ²éѯÆäËû±íÊDz»ÊÇÒ²ÊÇÒ»ÑùµÄ´íÎó?
Èç¹ûÊÇ,¾ÍµÃ¶Ô¿â½øÐÐ
SQL code
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://w
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......