Explain the concept of recursive stored procedure.

0 Answers  

---

Find nth lowest salary or get nth lowest salary?

0 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 is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

What are the types of stored procedures in an sql server?

0 Answers  

---

How to create prepared statements using odbc_prepare()?

0 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---

How to connect of datebase with sql express.?

0 Answers   MCN Solutions,

---

How to verify the port number of the sql server?

0 Answers  

---

Describe in brief sql server monitoring ways.

0 Answers  

---