100分急求,把这句SQL 转换为 STRING 的command命令 在线等
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’
[解决办法]
你的单引号怎么都是全角的‘？
使用 '
[解决办法]
dim cmd as SqlCommand
dim strSql as string
strSql= "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 ' "
set cmd = new SqlCommand(strSQL, connection);
dim myReader as SqlDataReader
myReader = cmd.ExecuteReader();
