• Advertisement

Archived

This topic is now archived and is closed to further replies.

Whats wrong w/ this sql?

This topic is 5273 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

I have a stored procedure that is acting weird. It doesn''t like taking in the parameter @Category, if i take everything about @Category, it acts fine. I get error msg 170 and Line 1: Incorrect syntax near ''whateversecondvariableiput''. Help plz ------------------------------------------------ CREATE PROCEDURE stpAddProduct(@Product_Name char(20), @NewCategoryNum int) AS DECLARE @NewProductKey int SET @NewProductKey = (SELECT MAX(PKey) FROM tlkpProduct_Name) INSERT INTO tlkpProduct_Name (Product_Name,Category,PKey) VALUES(@Product_Name, @NewCategoryNum, @NewProductKey+1) GO ------------------------------------------------- thanks! ----------------------------------------------------------- Like a sponge!

Share this post


Link to post
Share on other sites
Advertisement
Strange post for opengl forum but what database you using?

sql server should be
-----------------------------------------------
CREATE PROCEDURE

@Product_Name char(20),
@NewCategoryNum int

AS
BEGIN



END

GO

Share this post


Link to post
Share on other sites

  • Advertisement