Posted by JJ297 on 10/29/07 17:50

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!

• Next in forum: Re: Error message with stored procedure
• Prev in forum: Error message in DTS
• Thread view: Error message with stored procedure

[Reply to this message]