What are the usage of SAVEPOINTS?

Answer Posted / tulsi

1)In savepoint we can only rollback to every point the
savepoint is issued but we cant do commit at every savepoint

Is This Answer Correct ?    16 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the qualities of 2nf?

546


What if we write return in procedure?

788


what are date and time functions in mysql? : Sql dba

541


Can sql function call stored procedure?

562


What is cartesian join in sql?

559






What is trigger types in sql?

537


what is the difference between truncate and drop statements? : Sql dba

558


What's the difference between a primary key and a clustered index?

520


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

535


How do I know if I have sql express or standard?

608


Does inner join remove duplicates?

524


What are field types?

541


What is an example of translating a date into julian format?

582


how to create a test table in your mysql server? : Sql dba

500


What is left join example?

504