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

´æ´¢¹ý³ÌÖÐ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


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

SQL ÈÕÆÚת»»

http://xujunprogrammer.blog.hexun.com/8376520_d.html
SQL ServerÖÐÎİæµÄĬÈϵÄÈÕÆÚ×Ö¶Îdatetime¸ñʽÊÇyyyy-mm-dd Thh:mm:ss.mmm
ÀýÈç:
select getdate()
2004-09-12 11:06:08.177
Õâ¶ÔÓÚÔÚÒª²»Í¬Êý¾Ý¿â¼ä×ªÒÆÊý¾Ý»òÕßϰ¹ßoracleÈÕÆÚ¸ñʽYYYY-MM-DD HH24:MI:SSµÄÈ˶àÉÙÓÐЩ²»·½±ã.
ÎÒÕûÀíÁËÒ»ÏÂSQL ServerÀïÃæ¿ÉÄ ......

SQL °æ±¾²éѯ¼°¶ÔÓ¦¹ØÏµ

Òª»ñµÃÕýÔÚÔËÐеÄSQL Server 2005µÄ°æ±¾ºÅ£¬¿Éͨ¹ýSQL Server Management StudioÁ¬½Óµ½¸Ã·þÎñÆ÷£¬È»ºóÔËÐÐÒÔÏÂSQLÓï¾ä£º
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Ðк󣬿ɵõ½ÐèÒªµÄ°æ±¾ÐÅÏ¢£¬ÀýÈçÔÚÎҵĻúÆ÷ÉÏÔËÐкóµÃµ ......

[SQL 2000]·¢Éú´íÎó1069£ºÓÉÓڵǼʧ°Ü¶øÎÞ·¨Æô¶¯·þÎñ

ͬʱÆô¶¯ÆäËûsql ·þÎñ»á³öÏÖ ´íÎó1068:ÒÀ´æ·þÎñ»ò×éÎÞ·¨Æô¶¯£¨ÕâÊÇÓÉÓÚ¼¸¸öÏà¹ØÁªµÄ·þÎñÖÐÓÐÒ»¸ö²»ÄÜÆô¶¯£©¡£
´íÎó1069ÊÇÒ»¸öWindows NT/2000µÄϵͳ´íÎó¡£´íÎó1069±íÃ÷·þÎñ²»Äܱ»Æô¶¯£¨µ±Æô¶¯·þÎñʱ·µ»Ø“µÇ¼ʧ°Ü”´íÎ󣩡£ÀýÈ磬µ±Æô¶¯MSSQLServer·þÎñʱ£¬µÃµ½ÈçÏ´íÎóÌáʾ£º
·¢Éú´íÎó1069£ºÓÉÓڵǼʧ° ......

ÓÃÓÚ·ÖÒ³ÏÔʾµÄSQLÎÄ

Ô­Ö· http://technet.microsoft.com/ja-jp/library/cc411406.aspx
 
¿´ÁËһƪSQL2005¹ØÓÚTransact-SQLµÄÇ¿»¯¼¼ÄܵĽéÉÜ£¬¾õµÃºÜÓÐÓô¦£¬¼òµ¥×ܽáÁËһϡ£
 
£¨Ò»£©Êý¾Ý¿â×ö³É
USE tempdb – »òÕßн¨Ò»¸öDB
CREATE TABLE SpeakerStats
(
  speaker      &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ