SELECT [id]
      ,[name] '费用项目'
      ,[money] '支出金额'
      ,[dat] '日期'
      ,[bz] '备注'
      ,[renyuan1] '取款人'
      ,[renyuan2] '经手人'
      ,[financecheck] '审核状态'
      ,[time] '时间'
      ,[photo] '收据相片'     -- 导出xls时, 相片是导不出的, 注释掉;
      ,[hasphoto] '有无相片'
  FROM [Internal].[dbo].[gudingfeiyong]
 -- where [dat] between '2016-01-01 00:00:00' and '2016-12-31 23:59:59'