Append Query 1

[GammelNok]

I am trying to create a stored procedure using two parameters to append a new record to an existing table

any tips gratefully received
Any takers?

Cheers

Hans

 

[JamesLean]

CREATE PROC apInsertData
  @p1 varchar(20),
  @p2 int
AS

INSERT table1 (col1, col2)
VALUES @p1, @p2
GO

--James

 

[JamesLean]

Oops, the VALUES should have parentheses:

INSERT table1 (col1, col2)
VALUES (@p1, @p2)

--James