Results 1 to 2 of 2
  1. 11-13-2008, 02:22 PM #1
    sankarigopi
    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
    Reply With Quote Reply With Quote
  2. 11-13-2008, 04:53 PM #2
    Eranga's Avatar
    Eranga
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,370
    Blog Entries
    1
    Rep Power
    23

    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?
    Reply With Quote Reply With Quote
« [SOLVED] mysql | Need serious help here »

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

Bookmarks

Posting Permissions

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

Forum Rules