In a stored procedure 4 select stmts there.If error comes in one select stmt wi

Categories >> Software >> Microsoft Related >> C Sharp
Suggest New Category

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

Question Posted / swapna

7 Answers
13020 Views
Microsoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / anil er

Is This Answer Correct ?

2 Yes

0 No

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

Answer / gopinath

Stored Procedure compiled Successfully.
when passing parameters to the stored procedure and executed
it shows the actual error.

Is This Answer Correct ?

2 Yes

0 No

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

Answer / kanan

@rajesh
when you write answer , first check practically.

The Answer is NO
the reaming statements does not executes.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / ramesh

Yes ... It will execute the remaining statements. This is
one of the difference between stored procedure and function

Is This Answer Correct ?

1 Yes

1 No

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

Answer / 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

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

Answer / vijaykumar

Yes

Is This Answer Correct ?

0 Yes

1 No

Post New Answer