Problem with stored procedure

Discussion in 'Databases' started by renfaireman, Sep 13, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. renfaireman

    renfaireman

    Okay, I based this procedure from the microsoft IBuySpy starter kit. But All I am getting for returns is null. Help!

    CREATE PROCEDURE Test
    (
    @TransID int,
    @Fullname nvarchar(70) OUTPUT
    )
    AS
    SELECT @FullName = FullName
    FROM Actors
    WHERE TransID = @TransID
    GO
     
    renfaireman, Sep 13, 2003
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    what are you trying to do?


    quote:Originally posted by renfaireman

    Okay, I based this procedure from the microsoft IBuySpy starter kit. But All I am getting for returns is null. Help!

    CREATE PROCEDURE Test
    (
    @TransID int,
    @Fullname nvarchar(70) OUTPUT
    )
    AS
    SELECT @FullName = FullName
    FROM Actors
    WHERE TransID = @TransID
    GO

    </blockquote id="quote"></font id="quote">
     
    Bruce, Sep 13, 2003
    #2
  3. Darrick

    Darrick

    CREATE PROCEDURE Test

    @TransID int

    AS
    SELECT FullName
    FROM Actors
    WHERE TransID = @TransID
    GO





    quote:Originally posted by renfaireman

    Okay, I based this procedure from the microsoft IBuySpy starter kit. But All I am getting for returns is null. Help!

    CREATE PROCEDURE Test
    (
    @TransID int,
    @Fullname nvarchar(70) OUTPUT
    )
    AS
    SELECT @FullName = FullName
    FROM Actors
    WHERE TransID = @TransID
    GO

    </blockquote id="quote"></font id="quote">
     
    Darrick, Sep 18, 2003
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page