I am creating a trigger in SQL to update a table under certain circumstances. The table I am updating has a record ID number. I want to count the number of records in the table and assign that count to a variable so that I can then later add one to get the next record ID. How do I do this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.