开发者

'/' as alias name creates error

开发者 https://www.devze.com 2022-12-14 23:08 出处:网络
I am exporting from a database to excel.While doing so it is exporting the records as such to the excel.

I am exporting from a database to excel. While doing so it is exporting the records as such to the excel.

So I am using an alias name to modify the query in c#.net but it generates an error.

The query is

select n开发者_开发问答ame as personsname,eventtime as Date/time from mytable

Here the Date/time as alias name creates error

Can anybody guide me to get out of this?


Use [Date/time]

select name as personsname,eventtime as [Date/time] from mytable
0

精彩评论

暂无评论...
验证码 换一张
取 消