I am relatively new in creat store procedure
Please help me. I don't know why it does not work.
CREATE PROCEDURE dbo.usp_DeleteBigProjects
@Successfull int Out,
@BigProjectid int
AS
select @Successfull = 3000
begin
SET NOCOUNT ON
delete tblprojects where bigprojectid = @BigProjectid
end
RETURN @Successfull
Then I go to Query analyser and type
declare @Successfull int
set @Successfull = 1
exec usp_DeleteBigProjects @Successfull = 9, @BigProjectid ='5'
print cast(@Successfull as varchar(5))
I always get 1. But in my store procedure I did change @Successfull = 3000. Please help
