我正在尝试在SQL查询中使用变量，但失败了。用什么方法做到这一点？
var SicilNumvber = SessionCurrentUser.EMPNO;
string query = "select * from crm_visible_v where ownerid in (select sicilno from personel.pkim_kutlama@netdb_1.europe.nortel.com where cikis_tarihi is null start with sicilno = :SicilNumvber connect by prior sicilno = amir)";
问候
成功查询如下：感谢您的帮助；
string query = "select * from crm_visible_v where ownerid in (select sicilno from personel.pkim_kutlama@netdb_1.europe.nortel.com where cikis_tarihi is null start with sicilno ='"+SicilNumvber+"' connect by prior sicilno = amir)";
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句