Apr 25, 2003 #1 GammelNok Programmer Jun 21, 2002 32 0 0 US 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
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
Apr 25, 2003 1 #2 JamesLean Programmer Dec 13, 2002 3,059 0 0 GB Code: CREATE PROC apInsertData @p1 varchar(20), @p2 int AS INSERT table1 (col1, col2) VALUES @p1, @p2 GO --James Upvote 0 Downvote
Code: CREATE PROC apInsertData @p1 varchar(20), @p2 int AS INSERT table1 (col1, col2) VALUES @p1, @p2 GO --James
Apr 25, 2003 #3 JamesLean Programmer Dec 13, 2002 3,059 0 0 GB Oops, the VALUES should have parentheses: Code: INSERT table1 (col1, col2) VALUES (@p1, @p2) --James Upvote 0 Downvote