Stored proc with asp.net

[Mark]

Hi
I have a stored proc that inserts values into a db, now i
want to give that stored proc a row Id for it to update.
cant get it working though
heres the code
<code>
ALTER PROCEDURE dbo.AddPay
(
@Pay VarChar(50)
)
AS
Insert into TestFile
(
Pay
)Values (
@Pay
where Id = @Id)
</code>

any ideas?
thanks
Mark

[Hans Kesting]

see inline

"Mark" <an*******@discussions.microsoft.com> wrote in message
news:09****************************@phx.gbl...

Hi
I have a stored proc that inserts values into a db, now i
want to give that stored proc a row Id for it to update.
cant get it working though
heres the code
<code>
ALTER PROCEDURE dbo.AddPay
(
@Pay VarChar(50)
)
AS
Insert into TestFile
to change a row you need an UPDATE command
(
Pay
)Values (
@Pay
where Id = @Id)
this closing ) should be after the last value (before the "where")
</code>

any ideas?
thanks
Mark