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

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.

ÒýÓÃ
´øÉÏÊý¾Ý¿âËùÓÐÕß ÈçÏ£º
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


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

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

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

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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 ......

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

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