not able to understand that store procedure running recursively or not

Question

Post reply

not able to understand that store procedure running recursively or not

DataAroma

SSC Enthusiast

Points: 184
More actions
June 11, 2013 at 2:56 am

#278403

create procedure testRecur()
BEGIN
if
call testRecur();
end if;
select 'hi'; //This return does not execute anymore even I cant debug that procedure running
//recursively or not END

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33506 More actions · Answer 1

Your post is very unclear. The code provided does not parse (syntax errors) and cannot be executed.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

DataAroma (6/11/2013)
create procedure testRecur()
BEGIN
if
call testRecur();
end if;
select 'hi'; //This return does not execute anymore even I cant debug that procedure running
//recursively or not END

Posted code, as it is, does not constitute a valid T-SQL code.

Please clarify and post exactly one you are trying to execute.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

DataAroma (6/11/2013)
create procedure testRecur()
BEGIN
if
call testRecur();
end if;
select 'hi'; //This return does not execute anymore even I cant debug that procedure running
//recursively or not END

Your question is unclear to us and not correct. Its not an complete code

please refer the link below posting any question:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

mahavidhya24 SSC Veteran Points: 204 More actions · Answer 4

Ur code is unable to understand specify your doubt and use clear SQL query.