Hi Guys,
I have a table that stores the last no. generated by the previous transactions. Is it possible to get the next number then update the table with the new number using stored procedure?
Can you please give me an example of how to do it properly.
Thanks in advance...
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.