[thelist] SQL: Accessing Data in a Stored Procedure
MILLER David R.
dmiller at mcc.ca
Tue Dec 5 09:33:44 CST 2000
>CREATE PROC spSFDelete
> @SFFileName nvarchar(255)
>AS
> DECLARE @SFID int
> SELECT @SFID = SELECT ID FROM SF WHERE NAME=@SFFileName
> ...
>And it blows up right on that last line.
Since @SFFileName is character, you need quotes.
SELECT @SFID = SELECT ID FROM SF WHERE NAME='@SFFileName'
Ensure that SELECT ID returns only a single row or it won't work.
HTH
---------------FROM-------------------
David R. Miller
Manager, Computer-Based Testing
Medical Council of Canada
dmiller at mcc.ca
(613) 521-6012
(613) 521-9722 (fax)
-----------------------------------------
More information about the thelist
mailing list