【数据格式转换】
tips1:字符型→整型
eg:
select(CAST((SELECT TIMER FROM dbo.[8号机时段工作时长_分钟ID] WHERE ID=1) AS int )) AS RES
Explain:
- SELECT() as clo_name 选择某一范围的数据作为clo_name 列的数据
- CAST(statement AS int ) 将某一范围的数据转化为int型(可嵌套)
【数据格式转换】
tips1:字符型→整型
eg:
select(CAST((SELECT TIMER FROM dbo.[8号机时段工作时长_分钟ID] WHERE ID=1) AS int )) AS RES
Explain: