Problem using Input parameters

[Rob G]

Hello,

I know Access 2K pretty well and now I am trying to learn SQL Server.
Someone suggested I use Access Projects to get my feet wet.

Using an Access Project, I made a Stored Procedure that has an Input
parameter. The code is as follows:

Alter Procedure ActiveOrTerm
@Status nvarchar
SELECT Name, PS_Status
FROM Master
WHERE PS_Status = @Status

When I run the Procedure and am prompted for the Status, I enter it (either
Active or Term) and get nothing (I don't put any quotes or anything). When I
change the procedure to this:


Alter Procedure ActiveOrTerm
@Status nvarchar

SELECT Name, PS_Status
FROM Master
WHERE PS_Status = 'Active'

It works fine. Although I just get the Active people, obviously.

Could someone tell me what I am doing wrong?

Thanks.

-Rob

p.s. The PS_Status field is datatype nvarchar, if that makes a difference.

 

[Lyle Fairfield]

Hello,

I know Access 2K pretty well and now I am trying to learn SQL Server.
Someone suggested I use Access Projects to get my feet wet.

Using an Access Project, I made a Stored Procedure that has an Input
parameter. The code is as follows:

Alter Procedure ActiveOrTerm
@Status nvarchar
SELECT Name, PS_Status
FROM Master
WHERE PS_Status = @Status

When I run the Procedure and am prompted for the Status, I enter it
(either Active or Term) and get nothing (I don't put any quotes or
anything). When I change the procedure to this:


Alter Procedure ActiveOrTerm
@Status nvarchar

SELECT Name, PS_Status
FROM Master
WHERE PS_Status = 'Active'

It works fine. Although I just get the Active people, obviously.

Could someone tell me what I am doing wrong?

Thanks.

-Rob

p.s. The PS_Status field is datatype nvarchar, if that makes a
difference.

@Status nvarchar(n)

where n = length of PS_Status

 

[Rob G]

Lyle,

Thanks so much! That worked.

I really appreciate it.

-Rob