is there any way to create savepoint without using transaction?

Question

I have some queries such as update, delete.. etc.

Before i run them i want to create savepoint (without using transaction). But "how?" I don't know because savepoint is part of transaction. Is there another way to achieve this job?

Answer 1

No there is no way to create a save point without a transaction.

In absence of a transaction the concept is meaningless.

If you are looking at reducing locking that will be generated due to the transaction, have a look at snapshot isolation.