Need help with very simple stored procedure. Syntax error with ) as the error. Not sure where to put it.
Posted on 2008-11-06
I am trying to create a procedure that updates a table with a single record in it. This record serves nothing more than as a counter. I am getting a syntax error of ) and am not sure what I am missing. Can some one point me in the right direction?
Here is my code:
/****** Object: StoredProcedure [dbo].[WritePHIVerCounter] Script Date: 11/06/2008 22:48:06 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE Proc [dbo].[WritePHIVerCounter]
SET NOCOUNT ON
UPDATE [DRRPHI] (ID)
SET NOCOUNT OFF