Start New Discussion within our Software Development Community

Dear All

I am using to update a database running on SQL Server.

I am using the following to increase the value of the NextPlan in the SystemControl table in a SQL database.

Command.CommandText = "UPDATE SystemControl SET NextPlan = NextPlan + 1"

Once the Command is executed and I look in the actual database I can see the value has been incremented. How can I get the Command to return the new value of NextPlan so I don't need to then do a table read to get the new value.


This question has already been answered. Start a new discussion instead.