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,

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

What stored by the master?

0 Answers  

---

How dts is used to extract, transform and consolidate data?

0 Answers  

---

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

---

Do you know what is difference between stored procedure and user defined function?

0 Answers  

---

Can you explain different types of joins?

0 Answers  

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

what is spatial nonclustered index

0 Answers  

---

How do you size a resultset?

0 Answers  

---

Explain what is scheduled job and how to create it?

0 Answers  

---

What are the new data types are introduced in sql 2000?

0 Answers  

---