can we have a nested transaction? : Sql server database administration

0 Answers  

---

Explain linked server in sql?

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

---

What is the use of RDBMS?

0 Answers   Wipro,

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

How to rename databases in ms sql server?

0 Answers  

---

What is the definition for sql server 2000?

0 Answers  

---

How do I delete a sql server database?

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

Different types of keys in SQL?

0 Answers   Infosys,

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---