My Techie Blog

  Home  |   Contact  |   Syndication    |   Login
  110 Posts | 5 Stories | 405 Comments | 0 Trackbacks

News

Archives

Post Categories

ADO.NET

Ajax

API/WebServices

ASP.NET Resources

BizTalk Server

Blogs I read

Free Books

How to

iOT

JavaScript

JQuery

JSLink - SharePoint

JSON

LINQ

Misc

Mobile BI

MS Business Inteliigence

Reporting Services

Responsive/MVC ASP.NET

SEO

Sharepoint Resources/Tools

SharePoint 2010 Branding

SharePoint 2010 Videos

SharePoint 2013

SharePoint Online

SilverLight

SPServices

SQL Server

Sql Server 2012

SSIS

Web Optimization Tools

Web Performace Tools

Windows 8

Windows Azure

Windows Azure

Windows Phone

WorkFlows

WSS V3

xml

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 on Thursday, May 14, 2009 4:46 PM