Procedure or function has too many arguments specified?
When i use a stored proc and don't name it the same params as the column names i get this error.
My solution was to only make sure your stored proc runs in Query Analyzer and make sure if your column name is e.g lastname then param name must be @lastname.
If i use a different param name to the column name and i look at my sql profile i see this:
exec pr_updategetLastMonth @doc = NULL, @do = NULL, @ipa = NULL, @cdate = NULL, @title = N'N79', @DisplayOrder = N'187', @CreationDate = N'5/04/2009 5:06:33 PM', @Document = N'Nokia6260Slide.pdf', @IsPersonal = 1, @sid = 249
Its basically adding the params twice like above(AS YOU CAN SEE above @doc is the same as @Document and @do the same as @DisplayOrder etc..
Anyone with more updates on this...
posted @ Thursday, May 14, 2009 4:46 PM