Answer / lara

When a connection is operating in implicit transaction mode
MS SQL automatically starts a new transaction after the
current transaction is committed or rolled back.Implicit
transaction mode generates a continuous chain of
transactions.

An explicit transaction is one in which you explicitly
define both the start and end of the transaction.A user has
to use the BEGIN TRANSACTION, COMMIT TRANSACTION, COMMIT
WORK, ROLLBACK TRANSACTION, or ROLLBACK WORK Transact-SQL
statements to define explicit transactions.

Answer / vasudeva naik

Explicit transactions must be explicitly started with the
BEGIN TRAN statement, whereas no BEGIN TRAN is necessary to
start a multistatement transaction when in implicit
transaction mode.

Answer / anton

Implicit transactions are used automatically ACID
properties,mean would be updated or none of them would.

Explicit transactions are started by using the BEGIN
TRANSACTION T-SQL command and are stopped by using the
COMMIT TRANSACTION or ROLLBACK TRANSACTION commands.

Answer / chintan

IMPLICIT TRANSACTION: When turned on by using "SET
IMPLICIT_TRANSACTION ON" during transaction you have to
issue 'COMMIT TRAN' command in order to commit transaction.

EXPLICIT TRANSACTION: By default in SQL Server when you
finish a transaction it is committed to the database.

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What are the differences between decimal and float in ms sql server?

0 Answers  

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

What command must you use to include the not null constraint after a table has already been created?

0 Answers  

---

---

What is difference between joins and subqueries?

0 Answers  

---

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

---

What are the essential components of sql server service broker?

0 Answers  

---

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---

What do mean by xml datatype?

0 Answers  

---

What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

---