SQL Server error on stored procedure parameters
I'm getting a SQL Server error on a stored procedure (although it appears to run and run correctly). When I view the stored procedure call in my code, it is underlined, and the highlighted error message says: "Procedure sp_ReferenceSite has no parameters and arguments were supplied."
My procedure is called like this:
execute dbo.sp_ReferenceFieldwork @refColumnName='Comment', @FldWkID=@FieldInvId, @reference=@ref output
and the procedure is defined as
CREATE PROCEDURE [dbo].[sp_ReferenceFieldwork]
@refColumnName varchar(100),
@FldWkID int,
@reference varchar(8000) output
AS
As far as I can tell, all the cases are correct, the number of parameters are correct, the fiel开发者_如何学God types are correct. What's the problem? Or, at least, what might be the problem?
If it runs OK, then it's probably the Intellisense cache.
How to refresh it
It's brain dead: take it outside and shoot it. Replace with Redgate SQL prompt or similar.
精彩评论