存储过程为
SELECT * FROM OPENQUERY(INSQL,'UPDATE AnalogHistory SET Value=1,QualityDetail=192
WHERE TagName="SysTimeMin"
AND DateTime>"2005-12-05 09:28:00"
AND DateTime<"2005-12-05 09:30:00" ')
然后写到myCommand.CommandText = ""里面去
具体引号怎么打,谁能解释下,然后写出具体代码啊
SELECT * FROM OPENQUERY(INSQL,'UPDATE AnalogHistory SET Value=1,QualityDetail=192
WHERE TagName="SysTimeMin"
AND DateTime>"2005-12-05 09:28:00"
AND DateTime<"2005-12-05 09:30:00" ')
然后写到myCommand.CommandText = ""里面去
具体引号怎么打,谁能解释下,然后写出具体代码啊
WHERE TagName=""SysTimeMin""
AND DateTime>""2005-12-05 09:28:00""
AND DateTime<""2005-12-05 09:30:00"" ')";
WHERE TagName='SysTimeMin'''
SELECT * FROM OPENQUERY(INSQL,\"UPDATE AnalogHistory SET Value=1,QualityDetail=192
WHERE TagName='SysTimeMin'\")
WHERE TagName=""SysTimeMin""
AND DateTime>""2005-12-05 09:28:00""
AND DateTime<""2005-12-05 09:30:00"" ')";