Sql ²éѯ¼¼ÇÉ ÓÅÏÈÊä³öij½á¹û
SELECT EMP_ID,EMP_NO,LOGIN_NAME,EMP_NAME,SITE_CODE,DEPT_CODE,
JOB_DESC,HRMS_DEPT_CODE,MAIL_ACCOUNT,EXT_NO ,
(case when SITE_CODE='QCS' then 1 else 2 end) site
from dbo.AM_EMPLOYEE
WHERE ACTIVE = 'Y' AND EXT_NO = '6006'
order by site
ÏëÒªÔÚÔ±¹¤±íÖвé³öµç»°ºÅΪ6006µÄÔ±¹¤µÄÓ¢ÎÄÃûÀ´×÷ÎªÏµÍ³Ò³ÃæÉÏÊäÈëµç»°ºÅ´ø³ö¸ÃͬÈÊÓ¢ÎÄÃû¡£
¶øµ±Ç°ÏµÍ³Öе绰ºÅΪ6006Óжà±Ê¼Ç¼£¬ÓÐQCSµÄijA£¬QCHµÄijB,QTYµÄijC£¬
¶øµ±Ç°ÏµÍ³Ö»ÐèÊäÈëQCSµÄ½á¹û£¬ËùÒÔÓÃÉÏÊöÓï¾äÓÅÏÈÊä³öQCSµÄ¡£
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
Òª»ñµÃÕýÔÚÔËÐеÄSQL Server 2005µÄ°æ±¾ºÅ£¬¿Éͨ¹ýSQL Server Management StudioÁ¬½Óµ½¸Ã·þÎñÆ÷£¬È»ºóÔËÐÐÒÔÏÂSQLÓï¾ä£º
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Ðк󣬿ɵõ½ÐèÒªµÄ°æ±¾ÐÅÏ¢£¬ÀýÈçÔÚÎҵĻúÆ÷ÉÏÔËÐкóµÃµ ......
º¯ÊýÊÇÒ»ÖÖÓÐÁã¸ö»ò¶à¸ö²ÎÊý²¢ÇÒÓÐÒ»¸ö·µ»ØÖµµÄ³ÌÐò¡£ÔÚSQLÖÐOracleÄÚ½¨ÁËһϵÁк¯Êý£¬ÕâЩº¯Êý¶¼¿É±»³ÆÎªSQL»òPL/SQLÓï¾ä£¬º¯ÊýÖ÷Òª·ÖΪÁ½´óÀࣺ
µ¥Ðк¯Êý¡¢×麯Êý
±¾ÎĽ«ÌÖÂÛÈçºÎÀûÓõ¥Ðк¯ÊýÒÔ¼°Ê¹ÓùæÔò¡£
SQLÖеĵ¥Ðк¯Êý
SQLºÍPL/SQLÖÐ×Ô´øºÜ¶àÀàÐ͵ĺ¯Êý£¬ÓÐ×Ö·û¡¢Êý×Ö¡¢ÈÕÆÚ¡¢×ª»»¡¢ºÍ»ìºÏÐ͵ȶàÖÖº¯ ......
֮ǰµÄSQLÓï¾äÈçÏ£¬²éѯºÜÂý£¬6·ÖÖӶ඼ûÓнá¹ûÏÔʾ£¬Ò»¿ªÊ¼ÎÒÒÔΪÊÇ6ÕűíÁªºÏ²éѯ´øÀ´µÄËÙ¶ÈÂýµÄÎÊÌâ¡£
ºóÀ´·¢ÏÖÒòΪPO_D.ORDNOÓëPO_H.ORDNOÏàͬ£¬°ÑÂÌÉ«²¿·ÖÌæ»»Îª×ÏÉ«µÄ²¿·Ö£¬
°ÑPO_DÌæ»»ÎªPO_H£¬10ÃëÖÓ¾ÍÄܲéѯ³öÀ´
PS:PO_DÖÐ101401±ÊÊý¾Ý£¬PO_HÖÐ51341±ÊÊý¾Ý¡£
ËäûÓÐÏëÃ÷°×Ìæ»»Ö®ºóÌáËÙµ½Èç´ËÖ®¿ì½ö10Ã룬Óë6·Ö ......