What is a good example of a transaction in sybase?



What is a good example of a transaction in sybase?..

Answer / Ravish Kumar

A simple example of a transaction in Sybase might involve updating multiple tables atomically:nBEGIN TRANSACTION;nUPDATE table1 SET col1 = new_value1 WHERE condition1;nUPDATE table2 SET col2 = new_value2 WHERE condition2;nCOMMIT WORK;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Sybase Interview Questions

Is sybase free?

1 Answers  


What is replication server? What is its role in sybase?

1 Answers  


Are you doing the updates from within a cursor?

1 Answers  


Explain coalesce.

1 Answers  


How do I connect to sybase?

1 Answers  


What is cis and how can I use it?

1 Answers  


Explain the advantages of data integration suite in sybase.

1 Answers  


How do I turn off marked suspect on my database in sybase?

1 Answers  


What will happen if we create more indexes on a sysbase iq table?

1 Answers  


How do you check database space?

1 Answers  


Alternative to row at a time processing in sybase?

1 Answers  


What is the use 'return' keyword in Stored Procedure?

2 Answers  


Categories