select case
when 2 > (select count(*) from MyTable)as T then 0
else 2
end as 'myColumn'
老是报错:
Server: Msg 156, Level 15, State 1, Line 2
在关键字 'as' 附近有语法错误。
请问该怎么改?
...全文
2202打赏收藏
请问如何实现这条语句?
select case when 2 > (select count(*) from MyTable)as T then 0 else 2 end as 'myColumn' 老是报错: Server: Msg 156, Level 15, State 1, Line 2 在关键字 'as' 附近有语法错误。 请问该怎么改?