positive: "parameterType=""com.dsunsoft.cqhzz.sql.dto.I0203.I0203F0004SQL001DbcIU001""resultType=""com.dsunsoft.cqhzz.sql.dto.I0203.I0203F0004SQL001DbcOU001"">SELECTt1.USER_ID AS userId,t1.USER_NM AS userNm,t2.EM...<br>parameterType=""com.dsunsoft.cqhzz.sql.dto.I0203.I0203F0004SQL001DbcIU001""<br>resultType=""com.dsunsoft.cqhzz.sql.dto.I0203.I0203F0004SQL001DbcOU001"
negative: 在SQL Server 中使用DELETE和UPDATE的INNER JOIN关键字与 Access 的常规写法不同。<br>Access中写为:<br>delete from t1 inner join t2 on t1.id = t2.tid<br>而SQL Server中须写为:<br>delete from t1from t1inner join t2 on t1.id = t2.tid<br>注意蓝线部分!<br>同样,Update的写法也有所有不同。<br>Access中:<br>update t1 inner join t2 on t1.id = t2.tid set t1.name='Liu'<br>SQL Server中:<br>update t1 set t1.name='Liu' from t1 inner join t2 on t1.id = t2.tid