-- CRUD 操作 -- 查询Suppliers[]
SELECT 
	[SupplierID],[CompanyName],[ContactName],[ContactTitle],[Address],[City],[Region],[PostalCode],[Country],[Phone],[Fax],[HomePage]
FROM [Suppliers]
WHERE '<查询条件>'

-- CRUD 操作 -- 添加Suppliers[]
INSERT INTO [Suppliers] ( 
  [CompanyName],[ContactName],[ContactTitle],[Address],[City],[Region],[PostalCode],[Country],[Phone],[Fax],[HomePage]
) VALUES (
  '"+CompanyName+"','"+ContactName+"','"+ContactTitle+"','"+Address+"','"+City+"','"+Region+"','"+PostalCode+"','"+Country+"','"+Phone+"','"+Fax+"','"+HomePage+"'
)

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

-- SIDU 操作 -- 更新Suppliers[]
UPDATE [Suppliers] set 
  [CompanyName] = '"+CompanyName+"', --公司名称
  [ContactName] = '"+ContactName+"', --联系人名称
  [ContactTitle] = '"+ContactTitle+"', --联系人职务
  [Address] = '"+Address+"', --地址
  [City] = '"+City+"', --城市
  [Region] = '"+Region+"', --地区
  [PostalCode] = '"+PostalCode+"', --邮政编码
  [Country] = '"+Country+"', --国家
  [Phone] = '"+Phone+"', --电话
  [Fax] = '"+Fax+"', --传真
  [HomePage] = '"+HomePage+"' --主页
WHERE '<查询条件>'

