81,092
社区成员
发帖
与我相关
我的任务
分享
select ab as money, cd as moneyone,,,,,
[/quote]
你能帮我把
select *
from @t1
order by cast(SUBSTRING(fid,1,CHARINDEX('.',fid,1)-1) as money),
cast(SUBSTRING(fid,CHARINDEX('.',fid,1)+1,LEN(fid)) as money)
整个改正确么?
order by 后面的都看不懂。select ab as money, cd as moneyone,,,,,