Error message with stored procedure
- From: JJ297 <nc297@xxxxxxxxx>
- Date: Mon, 29 Oct 2007 10:50:44 -0700
Could someone help me, I'm getting this error message:
Procedure or function UpdateResources has too many arguments
specified.
Here's my stored procedure, I am trying to update four columns, two
are in the same table and two are in different tables. Any
suggestions?
CREATE PROCEDURE [UpdateResources]
(@titleID int,
@title varchar (255),
@description varchar (2047),
@quantityowned int)
AS Update Titles
SET
[title]=@title,
[description]=@description
where titleID=@titleid
Update classifications
set
[description]=@description
Update resources
set
[quantityowned]=@quantityowned
GO
I have two columns called description, on in the titles table and one
in the classification table.
Thanks!
.
- Follow-Ups:
- Re: Error message with stored procedure
- From: Plamen Ratchev
- Re: Error message with stored procedure
- Prev by Date: Error message in DTS
- Next by Date: Re: Error message with stored procedure
- Previous by thread: Error message in DTS
- Next by thread: Re: Error message with stored procedure
- Index(es):