What is a transaction and why is it important?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What do you mean by recursive stored procedure?

0 Answers  

---

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

---

What is tabulation?

0 Answers  

---

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

syntex of insert

7 Answers  

---

Can a function call a stored procedure in sql server?

0 Answers  

---

What is repeatable read?

0 Answers  

---

can you any body tell me the how to decrease the logfile

4 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

---