How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

What is function of ROLLUP ?

0 Answers   HCL,

---

How to defragment table indexes?

0 Answers  

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

How to assign null values to variables or columns?

0 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

What is difference between view and materialized view?

0 Answers  

---

How to find the version of sql server? : sql server database administration

0 Answers  

---

Which trace flags are enabled in sql server?

0 Answers  

---

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

---