| 12345678910111213 |
- 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'
|
