LOAD
各種原始字段
各種計算字段
RESIDENT 表名
ORDER BY 字段名 ASC
怎么存儲為QVD文件
store 各種字段
from 表名 into $(V_Path)Orders.qvd;
Store 表名 into $(V_Path)Orders.qvd;
store
Address,
City,
CompanyName,
ContactName,
Country,
CustomerID,
DivisionID,
Fax,
Phone,
PostalCode,
StateProvince
from Customers into $(V_Path)Customers.qvd;
怎么取QVD文件的數(shù)據(jù)
Automatic Creation of a QVD File in the Script
在腳本中自動創(chuàng)建 QVD 文件
Customers:
BUFFER (Stale After 7 days)
LOAD
各種字段名
;
SQL SELECT * FROM 表名;