Problem with stored procedure

[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

[bruce]

what are you trying to do?


[b]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]

CREATE PROCEDURE Test

@TransID int

AS
SELECT FullName
FROM Actors
WHERE TransID = @TransID
GO





[b]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">