100分急求,把这句SQL 转换为 STRING 的command命令小弟对引号,单引号给搞蒙了Select a.ID, a.NAME, IIF(a.MEASURE_TYPE = '2' And b.MIN_DATE is not null, Format(b.MIN_DATE, 'YYYY/MM/DD') + ' ' + a.MEASURE_TIME, b.MIN_DATE) As MIN_DATE, IIF(a.MEASURE_TYPE = '2' And MIN_DATE is not null, Format(DateAdd('d', 1, MAX_DATE), 'YYYY/MM/DD') + ' ' + a.MEASURE_TIME, b.MAX_DATE) As MAX_DATE, a.WESTNAME, a.WESTUNIT, a.PREVIE_TABNAME, a.MEASURE_TYPE
From T_SOURCE a Left Outer Join (Select SOURCE_ID, Min(REC_DATE) As MIN_DATE, MAX(REC_DATE) As MAX_DATE From T_SOURCE_VALUE Where PLANT_NAME = '1') b
On (a.ID = b.SOURCE_ID)
Where a.SOURCE_TYPE = '1'程序是VB.net
转换到string,c#和VB应该一样吧
From T_SOURCE a Left Outer Join (Select SOURCE_ID, Min(REC_DATE) As MIN_DATE, MAX(REC_DATE) As MAX_DATE From T_SOURCE_VALUE Where PLANT_NAME = '1') b
On (a.ID = b.SOURCE_ID)
Where a.SOURCE_TYPE = '1'程序是VB.net
转换到string,c#和VB应该一样吧
===============================
数据库操作应该一样哦
中间还有IIF(a.MEASURE_TYPE = '2' And b.MIN...
这样的
case<>
when then
when then
else
end
这个sql语句代替。
case<>
when then
when then
else
end
这个sql语句代替。