Looking at the sample data you have provided you need not use the studentRegNumber column in your table. You can just concatenate an A to your student ID in your query itself and get the result.
SELECT StdID, StdName, 'A' + CAST(StdID AS VARCHAR) AS StdRegNo FROM [YourTableName]
You can use
IDENTITY (Property)[
^] to auto generate the student ID.