-- CRUD 操作 -- 查询Orders[]
SELECT 
	[OrderID],[CustomerID],[EmployeeID],[OrderDate],[RequiredDate],[ShippedDate],[ShipVia],[Freight],[ShipName],[ShipAddress],[ShipCity],[ShipRegion],[ShipPostalCode],[ShipCountry]
FROM [Orders]
WHERE '<查询条件>'

-- CRUD 操作 -- 添加Orders[]
INSERT INTO [Orders] ( 
  [CustomerID],[EmployeeID],[OrderDate],[RequiredDate],[ShippedDate],[ShipVia],[Freight],[ShipName],[ShipAddress],[ShipCity],[ShipRegion],[ShipPostalCode],[ShipCountry]
) VALUES (
  '"+CustomerID+"','"+EmployeeID+"','"+OrderDate+"','"+RequiredDate+"','"+ShippedDate+"','"+ShipVia+"','"+Freight+"','"+ShipName+"','"+ShipAddress+"','"+ShipCity+"','"+ShipRegion+"','"+ShipPostalCode+"','"+ShipCountry+"'
)

-- CRUD 操作 -- 删除Orders[]
DELETE FROM [Orders] WHERE '<查询条件>'

-- SIDU 操作 -- 更新Orders[]
UPDATE [Orders] set 
  [CustomerID] = '"+CustomerID+"', --客户ID
  [EmployeeID] = '"+EmployeeID+"', --雇员ID
  [OrderDate] = '"+OrderDate+"', --订购日期
  [RequiredDate] = '"+RequiredDate+"', --发货日期
  [ShippedDate] = '"+ShippedDate+"', --到货日期
  [ShipVia] = '"+ShipVia+"', --运货商ID
  [Freight] = '"+Freight+"', --运货费
  [ShipName] = '"+ShipName+"', --运货商
  [ShipAddress] = '"+ShipAddress+"', --货主地址
  [ShipCity] = '"+ShipCity+"', --货主城市
  [ShipRegion] = '"+ShipRegion+"', --货主国家
  [ShipPostalCode] = '"+ShipPostalCode+"', --货主邮政编码
  [ShipCountry] = '"+ShipCountry+"' --货主国家
WHERE '<查询条件>'

