I tried to create the following stored procedure, but SQL syntax checker won't
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)
SET @p2 = '2000'
WHERE @p2 LIKE '1900%'