Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---

What is auditing in sql server?

0 Answers  

---

what is a stored procedure and trigger?

3 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

---

What are types of subqueries?

0 Answers  

---

Explain indexes disadvantages?

0 Answers  

---

How to find the date and time of last updated table?

3 Answers  

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

What is a cube? : sql server analysis services, ssas

0 Answers  

---

How to get all stored procedures in sql server?

0 Answers  

---

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

---