select top 10 * from SyssystemLog where SfcNo='SS20081824.' and CreatTime>=CAST(CAST(GETDATE() AS DATE) AS VARCHAR(10)) + ' 10:00:00'
此SQLSERVER不报错
select * from SyssystemLog where SfcNo='SS20081824.' and CreatTime>=CAST(CAST(GETDATE() AS DATE) AS VARCHAR(10)) + ' 10:00:00'
这个SQL预计报错从字符串转换日期和/或时间时,转换失败