In a stored procedure 4 select stmts there.If error comes in
one select stmt will remaining normally executes?

Answer Posted / rajesh

Hi Guys
If any sql statements throws an error in the stored
procedure it just ignore the error and the control is passed
to the next statement,But in the case of function if any sql
statements throws any error it won't executes.

Ans:yes

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do vs while c#?

656


What is windows application in c#?

650


What is the difference between dispose() and finalize() methods in c#?

696


Can a class have more than 1 destructor?

719


What is stringwriter c#?

603


What is static variable in c#?

665


What are primitive data types in c#?

696


To create a localized application which namespaces are necessary?

730


What is the diff between System.String and System.Text.StringBuilder classes?

736


Why do we use partial class in c#?

653


What are the different states of a thread?

701


What is the difference between static and constant variables?

740


Explain the difference between boxing and unboxing.

742


Write a program to create a user control with name and surname as data members and login as method and also the code to call it. (Hint use event delegates) Practical Example of Passing an Events to delegates

669


What is the difference between structure and class in c#?

668