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
What does .length do in c#?
Explain About ADO and its objects
Are c# destructors the same as c++ destructors?
What are callback methods in c#?
What is use of list in c#?
List the fundamental oop concepts?
if we are updating a database using thread, and mean while application crashes or thread being aborted then what will happen in Database? Rollback or Database will be updated? Please explain with different scenario.
What is routing in c#?
What do you know about device context?
What is the c# equivalent of c++ catch (…), which was a catch-all statement for any possible exception? Does c# support try-catch-finally blocks?
What is difference between string and stringbuilder in c#?
What is a nested type. Give an example?
What is dll file in c#?
What is serialization of data?
What does it mean?