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 get last system shutdown time in Sql server when restarted system?

1 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

---

What is the maximum size of sql server database?

0 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

How is table type constraint applied to a table?

0 Answers  

---

which backup strategy you are following at ur company

0 Answers  

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

What is the query optimization statistics?

1 Answers  

---

How to modify an existing stored procedure in ms sql server?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

Can you name a few encryption mechanisms in sql server?

0 Answers  

---