Skip to content
Advertisement

How to create id field with auto increasement while using stored procedure?

I have this stored procedure. How can I select a variable as a field that can +1 value in every row of results of sp? I need it for making a virtual id field. please help me.

Advertisement

Answer

Do you simply want row_number()?

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement