Dear freinds

I have create following store procedure then i got error in start transaction and convert function. Please help me for this issue.

Create procedure usp_get_next_content_id ()

begin

strat transaction

SELECT value FROM process_params WHERE code = 'NEXT_CONTENTID' ;

UPDATE process_params SET value = CONVERT(INT,value) + 1
WHERE code = 'NEXT_CONTENTID' ;

commit

END


thanks!
Anand

Have you copy pasted that?

We don't use start transaction in SQL Server; it's BEGIN TRANSACTION and COMMIT TRANSACTION (or even ROLLBACK TRANSACTION).

What is the data type of the column "value"? I'm going to assume it's not an integer, which is why you're converting it in the first place. If so, the resultant data type is an integer, so you'll need to convert it back to the original data type to get this to work. e.g.

thank you for your reply

I have done it but got same error as per following

Script line: 4 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Convert(int, value) + 1)
WHERE code = 'NEXT_CONTENTID';

END' at line 5

my advice is that you look up da syntax in da manual

that would certainly lead you to solving the CONVERT error a lot faster than posting on a forum and waiting for an answer

who cares???

dis be da MySQL forum

I didn't realise I was delving in to MySQL, my bad