I tried to create the following stored procedure, but SQL syntax checker won't
accept it.

Any idea what's wrong? I believe it has something to do with "UPDATE @p1".


CREATE PROC sp_FixFaultyDate @p1 VARCHAR(30), @p2 VARCHAR(30)
AS

UPDATE @p1
SET @p2 = '2000'
WHERE @p2 LIKE '1900%'


Thanks, everybody.