´æ´¢¹ý³ÌÖÐSql Óï¾ä²éѯËÙ¶ÈÓÅ»¯ ijÀý
֮ǰµÄSQLÓï¾äÈçÏ£¬²éѯºÜÂý£¬6·ÖÖӶ඼ûÓнá¹ûÏÔʾ£¬Ò»¿ªÊ¼ÎÒÒÔΪÊÇ6ÕűíÁªºÏ²éѯ´øÀ´µÄËÙ¶ÈÂýµÄÎÊÌâ¡£
ºóÀ´·¢ÏÖÒòΪPO_D.ORDNOÓëPO_H.ORDNOÏàͬ£¬°ÑÂÌÉ«²¿·ÖÌ滻Ϊ×ÏÉ«µÄ²¿·Ö£¬
°ÑPO_DÌ滻ΪPO_H£¬10ÃëÖÓ¾ÍÄܲéѯ³öÀ´
PS:PO_DÖÐ101401±ÊÊý¾Ý£¬PO_HÖÐ51341±ÊÊý¾Ý¡£
ËäûÓÐÏëÃ÷°×Ìæ»»Ö®ºóÌáËÙµ½Èç´ËÖ®¿ì½ö10Ã룬Óë6·ÖÖÓδ³ö½á¹û²îÒìÌ«´ó£¬µ«ÎãÓ¹ÖÃÒɵÄÊÇÓ¦¸ÃÒÔÊý¾ÝÁ¿Éٵıí
×÷Ïà¹ØÍâ¼ü²éѯÊÇ¿ÉÒÔÌá¸ßËٶȵġ£ËùÒÔÔÚдSQLÓï¾äʱעÒâ´Ë´¦¡£
SELECT (SELECT DEPT_CODE from AM_EMPLOYEE WHERE EMP_NO=PO_H.APPLICANT) AS DEPT_CODE,
(SELECT LOGIN_NAME from AM_EMPLOYEE WHERE EMP_NO=PO_H.APPLICANT) AS LOGIN_NAME,
PO_D.FPRNO,
PO_D.ORDNO,
PO_H.MDATE,
PO_T.ITDSC,
PO_T.ITEMSPEC,
PO_D.UMORD,
PO_D.ACTQY,
PO_D.POISQ,
PV.VENDOR,
PV.VNDNAM,
PO_H.CURCY,
PO_D.UNITP,
PO_T.ECDNO,
PC_PACN_LIST.PRICE,
(PC_PACN_LIST.PRICE-PO_D.UNITP) AS BALANCE
from
IPPOHM AS PO_H,
IPPODM AS PO_D,
IPAVM AS PV,
IPPOTM AS PO_T,
PC_PACN_LIST
WHERE
PO_D.ORDNO = PV.VORDNO
AND
PO_H.ORDNO =PO_D.ORDNO
AND
PO_D.ORDNO
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
Ò»¡¢²Ù×÷·ûÓÅ»¯
1¡¢IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵ģ¬´ÓOracleÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£¬Èç¹ûת»»³É¹ ......
Copy ÒÔÏÂÄÚÈݵ½²éѯ·ÖÎöÆ÷²Ù×÷£º
-- 3 ****************************************************
-- ÊìϤϵͳ×Ô´øµÄһЩº¯Êý
-- 3.1 --------------------------------------------------
-- Êýѧº¯Êý
-- ABS(num_expression) ·µ»Ø¸ø¶¨ÊýÖµ±í´ïʽµÄ¾ø¶ÔÖµ
-- C ......
Êý¾Ý¿âÀàÐÍΪDateTimeÀàÐÍ£¬½«Æä×öÄ£ºý²éѯʱ£¬ÔÚHibernateÖУ¬¿ÉÒÔÓÃÆ´SQLµÄÎÊÌ⽫Æä½â¾ö£¬¼´ÔÚSQL²éѯ·ÖÎöÆ÷дSQLÒ»Ñù£¬µ«ÊÇÀûÓòÎÊýÅäÖã¬Ôò·½·¨ÈçÏ£º
1¡¢Æ´ÉÏSQL,È磺
String beginPara= &q ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER function [dbo].[Get_StrArrayStrOfIndex]
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10), --·Ö¸ô·ûºÅ
@index int --È¡µÚ¼¸¸öÔªËØ
)
returns varchar(1024)
as
begin
declare @location int
de ......