sql语句带参数的模糊查询 （like @tag+'%')
摘要：
"select PK_SIR_ID,FK_SI_ID,SIR_NAME,SIR_VALUE,SIR_TAG from souce_item_results where FK_SI_ID in " + " ( select PK_SI_ID from souce_item where SI_UNIT_NUM= @iUnitNum and SI_CALCULATE_TIME=to_date(@CalculateTime,'yyyy-MM-dd') ) as SourceItem "+ " and SIR_TAG like @tag+ 阅读全文
posted @ 2013-07-31 10:28 中子持心 阅读(1429) 评论(0) 推荐(0)
浙公网安备 33010602011771号