sql.txt

来自「delphi实现的sql解析器」· 文本 代码 · 共 6 行

select * from parts  where (parts.OnOrder > parts.OnHand) 
select max(ItemNo)  from Items   where OrderNo = :OrderNo
select Customer.CustNo, Customer.Company, Customer.LastInvoiceDate, Customer.Phone from customer   where      (customer.LastInvoiceDate >= :FromDate) and     (customer.LastInvoiceDate <= :ToDate)
select * from customer order by LastInvoiceDate descending
select * from orders where      (SaleDate >= :FromDate) and     (SaleDate <= :ToDate) order by    SaleDate