as per usual my google searches havent quite cleared my exact problem and i cant extract a solution from them, and i wish to understand the situation. so here is my stored proc:
CREATE PROCEDURE insertPlayerImage @playerID varchar(9), @profileImage VARBINARY(max), @pending char(1)
AS
INSERT INTO PlayerImage(
playerID,
profileImage,
pending)
VALUES(
@playerID,
@playerImage,
@pending)
GO
I created the table with profileImage as a varbinary(max) and that works, the table is there. but this procedure says i must declare the scalar variable @playerImage
i have no idea why
Yes you have put @profileImage in the Stored Procedure method, not @playerImage.