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

What is difference between events and delegates?

491


Name some properties of thread class.

554


write code for inserting and updating recoards in sql server database using connected architecture & records shoulds displayed in grid view ( use c# )

1921


What type is string in c#?

481


To catch any possible exception What is the C# syntax written ?

543






What is void method?

491


What is a must for multitasking

567


Is versioning applicable to private assemblies?

570


Are value types sealed?

513


What is dbcontext c#?

484


What does immutable mean in c#?

506


What is default parameter in c#?

510


While debugging a C# application can you change the value of a variable?

540


How many dimensions can an array have?

469


Can we customize the serialization process?

526