Stored procedure returns no value

[nikolacace]

Hi,
I have a stored procedure (the code is below) that I use to retrieve
one value from my database. I tested the code in Query Analyzer, and it
works (I get the value I was looking for). However, when I call the
same code from the stored procedure, I get no value. The code that is
executed is the same and the input parameter is the same. Does anybody
have an idea?

The code:

SELECT Top 1
CharID,
CharName,
CategoryName,
CharDescription ,
UserID
FROM [Character]
WHERE CharName='Chara cter'

-- returns the right value

The Stored Procedure:

CREATE PROCEDURE SpCharacters_Se lectOneByUserNa me
@UserName NVarChar
AS
SELECT Top 1
CharID,
CharName,
CategoryName,
CharDescription ,
UserID
FROM Character
WHERE CharName=@UserN ame
GO

-- returns no value

[Niels Berglund]

ni********@gmai l.com wrote in
news:11******** **************@ v46g2000cwv.goo glegroups.com:

I have a stored procedure (the code is below) that I use to retrieve
one value from my database. I tested the code in Query Analyzer, and
it works (I get the value I was looking for). However, when I call the
same code from the stored procedure, I get no value. The code that is
executed is the same and the input parameter is the same. Does anybody
have an idea?

The code:

SELECT Top 1
CharID,
CharName,
CategoryName,
CharDescription ,
UserID
FROM [Character]
WHERE CharName='Chara cter'

-- returns the right value

The Stored Procedure:

CREATE PROCEDURE SpCharacters_Se lectOneByUserNa me
@UserName NVarChar
AS
SELECT Top 1
CharID,
CharName,
CategoryName,
CharDescription ,
UserID
FROM Character
WHERE CharName=@UserN ame
GO

-- returns no value

The @UserName param in your stored procedure defaults to 1 character the
way you have defined it. You need to give it a size in the declaration:

CREATE PROCEDURE SpCharacters_Se lectOneByUserNa me
@UserName NVarChar(50)

Niels
--
*************** *************** *************** *****
* Niels Berglund
* http://staff.develop.com/nielsb
* ni****@no-spam.develop.co m
* "A First Look at SQL Server 2005 for Developers"
* http://www.awprofessional.com/title/0321180593
*************** *************** *************** *****

[nikolacace]

Thanks Niels, it solved the issue..