Answer / Chandan Kumar Roy

Autocommit SQL refers to the automatic committing of transactions in SQL databases. By default, when each SQL statement is executed, it is committed immediately unless the transaction is explicitly begun and ended with a BEGIN TRANSACTION and COMMIT or ROLLBACK command.nnIn some cases, you might want to disable autocommit to have more control over multiple statements and manage them as a single unit of work. This can be done by starting an explicit transaction using the BEGIN TRANSACTION statement.nnFor example:n`nBEGIN TRANSACTION;n-- Multiple SQL statements herenCOMMIT;

When can we use the where clause and the having clause?

1 Answers  

---

What is index example?

1 Answers  

---

What is percent sign in sql?

1 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

What is a schema sql?

1 Answers  

---

Which command is used to delete a trigger?

1 Answers  

---

What is difference between inner join and cross join?

1 Answers  

---

Why do we need cursor in pl sql?

1 Answers  

---

How do I count duplicates in sql?

1 Answers  

---

Is sql better than excel?

1 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

How can I get the number of records affected by a stored procedure?

1 Answers  

---