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 happens if null values are involved in arithmetic operations?

0 Answers  

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What is data block and how to define data block size?

0 Answers  

---

What are ddl triggers and types of ddl trigger?

0 Answers  

---

What are orphan records?

0 Answers  

---

Can you explain the role of each service?

1 Answers  

---

How to provide default values to stored procedure parameters?

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

How to create a ddl trigger using "create trigger" statements?

0 Answers  

---

What is a data collection table?

0 Answers  

---