Answer Posted / dharmendra k. dixit

Basically a Transaction is a Series of work..which either
complete successfully or failed in Group.
there is ACID proerty in this
ACID stands for
A - Atomicity
C - Consistancy
I - Isolation
D - Durability

How can you find out how many rows returned in a cursor?

969

---

How to reaname table name without using sp_Rename in sql server..?

935

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2091

---

How is table type constraint applied to a table?

932

---

How is SQL Azure different than SQL server?

223

---

What is the query and subquery?

1025

---

What are tables in sql server?

961

---

What is the process of indexing?

941

---

How to perform key word search in tables?

908

---

How to retrieve error messages using odbc_errormsg()?

988

---

What is row_number()?

926

---

What is replication with database mirroring? : sql server database administration

985

---

How to provide login information for a new odbc dsn?

979

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

923

---

What is exporting and importing utility?

1015

---