Results 1 to 2 of 2
  1. #1
    sankarigopi is offline Member
    Join Date
    Nov 2008
    Posts
    1
    Rep Power
    0

    Default stored procedure

    hi i created stored procedure for simple table.
    i need to use LIKE operator by passing argument for exampe @employeename
    now i use like this
    a.employee_name like @EmpName +'%'
    but it is not working.can u pls tell some solution.
    thanks

  2. #2
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    20

    Default

    You saying that the query is not working as you expecting? In that case it's not related to Java, you should ask your question on a SQL forum.

    Anyway, did you try to execute that query on SQL query analyzer?

Similar Threads

  1. How to get multiple rows from Stored Procedure
    By SRJ1957 in forum Advanced Java
    Replies: 0
    Last Post: 08-11-2008, 08:26 PM
  2. Stored Procedures
    By geeta_ravikanti in forum JDBC
    Replies: 1
    Last Post: 04-22-2008, 02:34 AM
  3. Stored Procedures with java
    By Albert in forum JDBC
    Replies: 4
    Last Post: 06-08-2007, 05:59 AM
  4. stored procedures in Hibernate
    By Alan in forum JDBC
    Replies: 2
    Last Post: 05-31-2007, 04:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •