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

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

How to convert numeric expression data types using the cast() function?

0 Answers  

---

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---

What happens if null values are involved in arithmetic operations?

0 Answers  

---

How many cores do I need for sql server 2016?

0 Answers  

---