declare @HourSectWorkTime as intselect @HourSectWorkTime=floor(convert(float,SectWorkTime)) from ....现在我要完成select SectWorkTime from .....其中SectWorkTime 要由@HourSect... 展开
declare @HourSectWorkTime as intselect @HourSectWorkTime=floor(convert(float,SectWorkTime)) from ....现在我要完成select SectWorkTime from .....其中SectWorkTime 要由@HourSectWorkTime +“小时” (若@HourSectWorkTime 为1,即SectWorkTime 为 “1小时”)请教高手 ,如何实现两个字符合并为一个字符? 收起