Can we use save transaction command only in nested transactions?
I am a newbie to SQL and I came across a situation where I have to use save transaction


Savepoints are rarely used (or useful) and it's unusual that "a newbie" would "have to use save transaction".


  what is the difference between having a save point and not having a save point transaction in a Stored procedure where we don't use nested transactions


Save Points allow partial rollback.