Stored proc with asp.net

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
see inline

Mark said:
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
Click to expand...

to change a row you need an UPDATE command
(
Pay
)Values (
@Pay
where Id = @Id)
Click to expand...

this closing ) should be after the last value (before the "where")
 
Back
Top