Simple SQL Parameter problem

[Eric]

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.

[grig petrescu]

Yes,
you have to put instead @p1 a table name. If you want to use
a parameter for table name you have to use EXEC

grig petrescu

"Eric" <ericb@tfillc.com> wrote:
>
>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.