Hi,

I had this simple question on MS Sql2000 stored procedure.
I had a stored procedure which my vfp application will called through ADO to execute it.

Therefore, theoretically, I should be able to test the stored procedure using my own parameter as
show below in the SQL Query Analyzer as show below, right ?

DECLARE @RESULT varchar(255)
exec @RESULT = CMSSP_UpdateRegAddress(3,'238164','0','SOMERSET ROAD',0,'111','SINGAPORE POWER BUILDING',0,0,0,0)

However, I keep getting different type of errors.
Am I using the wrong syntax.

I hoping to use the Query Analyzer to test my input parameter.

Please kindly advise as I am new to MS SQL2000.

Thank you