stored procedure...

Results 1 to 2 of 2

Thread: stored procedure...

  1. #1
    Join Date
    Dec 1969

    Default stored procedure...

    I want to retrive some values from a db <BR>a="brij"<BR> "select * from registration where userid=&#039;"&a&"&#039;",conn<BR>This works perfectly fine i made a stored procedure.<BR>CREATE PROCEDURE spgetregdetails<BR>@dbuserid varchar<BR>AS<BR>SELECT * FROM registration where userid=@dbuserid<BR>go<BR><BR>and i call the same <BR> "spgetregdetails " & a,conn<BR>IT always returns EOF error.<BR><BR>brij<BR>

  2. #2
    Join Date
    Dec 1969

    Default Concatenate "spgetregdetails " & "&#039;a&#039;",conn<BR>

Posting Permissions

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