-- CRUD 操作 -- 查询Employees[]
SELECT 
	[EmployeeID],[LastName],[FirstName],[Title],[TitleOfCourtesy],[BirthDate],[HireDate],[Address],[City],[Region],[PostalCode],[Country],[HomePhone],[Extension],[Photo],[Notes],[ReportsTo],[PhotoPath]
FROM [Employees]
WHERE '<查询条件>'

-- CRUD 操作 -- 添加Employees[]
INSERT INTO [Employees] ( 
  [LastName],[FirstName],[Title],[TitleOfCourtesy],[BirthDate],[HireDate],[Address],[City],[Region],[PostalCode],[Country],[HomePhone],[Extension],[Photo],[Notes],[ReportsTo],[PhotoPath]
) VALUES (
  '"+LastName+"','"+FirstName+"','"+Title+"','"+TitleOfCourtesy+"','"+BirthDate+"','"+HireDate+"','"+Address+"','"+City+"','"+Region+"','"+PostalCode+"','"+Country+"','"+HomePhone+"','"+Extension+"','"+Photo+"','"+Notes+"','"+ReportsTo+"','"+PhotoPath+"'
)

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

-- SIDU 操作 -- 更新Employees[]
UPDATE [Employees] set 
  [LastName] = '"+LastName+"', --姓氏
  [FirstName] = '"+FirstName+"', --名称
  [Title] = '"+Title+"', --职位
  [TitleOfCourtesy] = '"+TitleOfCourtesy+"', --尊称
  [BirthDate] = '"+BirthDate+"', --出生日期
  [HireDate] = '"+HireDate+"', --雇用日期
  [Address] = '"+Address+"', --地址
  [City] = '"+City+"', --城市
  [Region] = '"+Region+"', --地区
  [PostalCode] = '"+PostalCode+"', --邮政编码
  [Country] = '"+Country+"', --国家
  [HomePhone] = '"+HomePhone+"', --家庭电话
  [Extension] = '"+Extension+"', --电话分机
  [Photo] = '"+Photo+"', --照片
  [Notes] = '"+Notes+"', --备注
  [ReportsTo] = '"+ReportsTo+"', --上级雇员
  [PhotoPath] = '"+PhotoPath+"' --图片路径
WHERE '<查询条件>'

