problems with this SP

microsoft.public.sqlserver.programming

30 Oct 2006 11:40 AM

Jeff

hey

My problem is that my select don't return any rows. As you see I have
commented out the "where" clause, because I thought the error was related to
it, but no it wasn't. The SP return no rows.. The table has about 20 rows,
so the output should have been the same...

The DBMS here is the sqlserver 2005 installed in visual studio 2005, and the
database was created by visual studio 2005 when I created my asp.net 2.0
project.... the database is located in the App_Data folder in my asp.net 2.0
project

When I test this SP, I right click on it in VS2005 and select "Execute" in
the popup menu

ALTER PROCEDURE AH_Test
AS
/*SET NOCOUNT ON*/
SELECT * /*sender, receiver, body, date_created*/
FROM AH_Messages;
/*WHERE sender = @senderId and receiver = @receiverId;*/

What am I doing wrong here?

Jeff