SQL INSERT INTO 順序不對, 無法使用 order by

最近在SQL SERVER 2008 上使用 INSERT INTO 時, 發覺塞入的資料沒有依日期排序, 而且後面也不能使用 order by 語法, 如下:  會出現語法錯誤

insert INTO dbo.VKAAJ_DAILYOFF 
        (DUTYDATE)
(
    SELECT WORKDATE
    FROM dbo.DUTYWORK A,DBO.WORKTIME B
    WHERE
    EMPLOYECD = @EMPLOYECD
    AND WORKDATE >=@BEGINDATE  AND WORKDATE <= @ENDDATE
    AND HOLIDAY = 'N'
    AND A.WORKTYPE = B.WORKTYPE
    AND A.COMPANYCD= B.COMPANYCD
    AND A.WORKDATE NOT IN
    (SELECT DUTYDATE FROM DBO.DAILYOFF WHERE
    EMPLOYECD = @EMPLOYECD
    AND WORKDATE >= @BEGINDATE AND WORKDATE <= @ENDDATE)
)
    ORDER BY WORKDATE
=========================================

後來將 () 拿掉就可以了

insert INTO dbo.VKAAJ_DAILYOFF 
        (DUTYDATE)

    SELECT WORKDATE
    FROM dbo.DUTYWORK A,DBO.WORKTIME B
    WHERE
    EMPLOYECD = @EMPLOYECD
    AND WORKDATE >=@BEGINDATE  AND WORKDATE <= @ENDDATE
    AND HOLIDAY = 'N'
    AND A.WORKTYPE = B.WORKTYPE
    AND A.COMPANYCD= B.COMPANYCD
    AND A.WORKDATE NOT IN
    (SELECT DUTYDATE FROM DBO.DAILYOFF WHERE
    EMPLOYECD = @EMPLOYECD
    AND WORKDATE >= @BEGINDATE AND WORKDATE <= @ENDDATE)

    ORDER BY WORKDATE

不同資料庫中查詢前10筆記錄的select用法

在不同資料庫中查詢前10筆記錄的Select用法

引用：http://blog.csdn.net/pric/archive/2004/09/19/109608.aspx

1. ORACLE SELECT * FROM TABLE1 WHERE ROWNUM<=10

2. INFORMIX SELECT FIRST 10 * FROM TABLE1

3. DB2 SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=10 或者SELECT COLUMN FROM TABLE FETCH FIRST 10 ROWS ONLY

4. SQL SERVER SELECT TOP 10 * FROM TABLE1

5. SYBASE SET ROWCOUNT 10 GOSELECT * FROM TABLE1

6. MYSQL SELECT * FROM TABLE1 LIMIT 10

7. FOXPRO SELECT * TOP 10 FROM TABLE ORDER BY COLUMN

http://blog.blueshop.com.tw/jacksun/archive/2007/02/28/49737.aspx

per檔中 folder 主畫面問題

程式如下:

SCHEMA FORMONLY LAYOUT

FOLDER

PAGE page01(TEXT="Page01")

GRID

{

Hello,world. This is page01

}

END END

PAGE page02(TEXT="Page02")

GRID

{

Hello,world. This is page02

}

END

END END

###################

畫面中看到的主畫面應該是 Page01, 不知為何會出現 主畫面

Vincent
2007.03.01