התחלתי לכתוב SP ב MS-SQL
and encountered this error message: Must declare the variable ´@chCamp´. this is the code....can some1 help?? CREATE procedure dbo.upd_close @chCamp char(9), @vchAd varchar(10), @vchPar varchar(10), @iTime int = 0 AS IF EXISTS(SELECT * FROM @chCamp WHERE trk_ad=@vchAd and trk_prm=@vchPar and trk_date=GETDATE()) BEGIN /* UPDATE QUERY */ END ELSE BEGIN /* INSERT QUERY */ END GO
and encountered this error message: Must declare the variable ´@chCamp´. this is the code....can some1 help?? CREATE procedure dbo.upd_close @chCamp char(9), @vchAd varchar(10), @vchPar varchar(10), @iTime int = 0 AS IF EXISTS(SELECT * FROM @chCamp WHERE trk_ad=@vchAd and trk_prm=@vchPar and trk_date=GETDATE()) BEGIN /* UPDATE QUERY */ END ELSE BEGIN /* INSERT QUERY */ END GO