-->正确应该这样写:
select Convert(NVCHAR(50),column1) as [column1],
Convert(NVCHAR(50),column2) as [column2]
from tbl
where [column1] = 'value'
select Convert(NVCHAR(50),column1) as [column1],
Convert(NVCHAR(50),column2) as [column2]
from tbl
where [column1] = 'value'
楼上的没错
但是问题不在这
而是我想使用列别名(有数据类型转换)而引入as tmp 的
select * from
(select Convert(NVCHAR(50),column1 as [column1]),
Convert(NVCHAR(50),column2 as [column2])
from tbl)
as tmp
where [column1] = 'value'
这个语句有first-chance c++ exception 而Open成功,得到数据正常
在sql server 查询分析器直接执行正常
不解