Answer / bru medishetty

You can use RaiseError or use the TRY CATCH Programming in
the Stored Procedure Code.

Thanks,
Bru Medishetty
www.LearnSQLWithBru,com

Answer / veeresh kethari

With simple example:

begin try
declare @int int
set @int='select 1/0'
end try
begin catch
print 'Error detected with error number -'+convert(char
(10),@@error)
end catch

How to modify the underlying query of an existing view?

0 Answers  

---

What is difference between delete & truncate commands?

0 Answers  

---

which backup strategy you are following at ur company

0 Answers  

---

What happens if null values are involved in string operations?

0 Answers  

---

What are subqueries in sql server? Explain its properties.

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

Mention the differences between having and where clause.

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

what is a check constraint?

0 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---

What is a join in sql? What are the types of joins?

0 Answers  

---

What do you mean by acid?

0 Answers  

---