Problem with Stored Procedures

[davek2]

Hi,

Im trying to have an aspx page call a Stored procedure that inserts a record into a database.

My stored procedure is relatively simple, it looks like this:

CREATE PROCEDURE sp_Insert_Data AS
INSERT INTO spHits (SPRNumber) VALUES ('Test')


Thats all it is and the syntax checks fine, but when the aspx page tries to run it I get this error:

Line 1: Incorrect syntax near 'sp_Insert_Data'.

Im pretty sure the syntax is correct. Any Ideas?

Thanks,
Dave

 

[Kirilla]

Hi.

I'm not sure, but try the following:

CREATE PROCEDURE [sp_Insert_Data]
AS INSERT INTO spHits (SPRNumber) VALUES ('Test')

May be the square brackets are missing. In SQL they have to be present.

regards, Kiri

 

[adf999]

does the sp run from query analyser? are you passing parameters to the sp or does it always write 'test'

Dave
adf999@hotmail.com