Answer Posted / ashique

Transaction is a database operation that satisfies following
a condition called ACID:

A (Atomicity) : Do all the operations successfully Or None.
C (Consistency) : The operation should not violate data
integrity concept.
I (Isolation) : When one person is manipulating the data,
others should wait (i.e synchronization).
D (Durability): Once transaction is over succesfully, the
changes should be permanent at any cost.

The best example of a simple transaction is bank fund
transfer from one account to another. Try to implement above
points using your common sense. Thank you :)

What is dbcc? Give few examples.

1086

---

What area unit the various kinds of info compression introduced in sql server 2008?

1141

---

How do I create an extended event in sql server?

1005

---

What is user-defined function?

1035

---

What is pivot and unpivot?

1066

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2141

---

How to rename an existing column with sql server management studio?

1055

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1064

---

Can sql servers link to other servers?

1141

---

Explain system rowset functions?

1046

---

Can we add our custom code in ssis?

1040

---

What are the new features of sql server 2008 r2 reporting service?

212

---

how to take backup bcp out for a column in table in sql server?

2145

---

What is normalization 1nf 2nf 3nf?

1112

---

How do I open a .db file?

1082

---