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

Answer Posted / venkatesh

@Kanan. Yes it ll execute. It is based on the sp.

For Example In that SP first two table have no error and the third table have error means ,
It ll give the First two tables results set then 3rd one ll show error,but it ll not show the 4th table results

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the sum of last 3 items in a list using lambda expressions?

692


What is an int c#?

625


Explain the differences between static, void and public in c#?

731


Is predicate a functional interface?

698


What is ado c#?

709


What are the properties in c#?

674


Explain manifest & metadata in c#.

729


In a single .NET DLL how many classes it contains?

698


What is the purpose of dependency injection?

678


What is difference between virtual and override in c#?

628


What is the difference between values and reference types?

690


What is meant by clr?

747


How to prevent the error while updating ui control from another thread?

695


Enlist all the components of an ado.net framework?

645


Can I define a type that is an alias of another type (like typedef in c++)?

753