Unanswered: how can i use Prepared statement in SQL SERVER?
when i use prepared statement in SQL Server 2000, i found the problem addressed in "LIKE" operator.
pstmt = con.prepareStatement("select * from userinfo where userName like ?");
rs = pstmt.executeQuery() ;
it doesn't works! but if i copy the whole string"select * from userinfo where userName like 'rickey%'" in SQL Server query analyzer, it can select out the result. why? should I use another character instead of "?" ?
please help me.....