goto in sql server 2000 stoed procedure
-
in stored procedure sql server 2000 , i am using the goto keyword to send the user to execute the particular line , Is this the right way to do so ? I am saying this because , in general , we are told to stop using the goto keyword , as far as the memory consumption is concerned.
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
-
in stored procedure sql server 2000 , i am using the goto keyword to send the user to execute the particular line , Is this the right way to do so ? I am saying this because , in general , we are told to stop using the goto keyword , as far as the memory consumption is concerned.
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
Sonia Gupta wrote:
we are told to stop using the goto keyword , as far as the memory consumption is concerned.
I'm not sure why memory consumption should be an issue. The traditional arguments against using GOTO are outlined in this article[^]. What are you using GOTO for?
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
-
Sonia Gupta wrote:
we are told to stop using the goto keyword , as far as the memory consumption is concerned.
I'm not sure why memory consumption should be an issue. The traditional arguments against using GOTO are outlined in this article[^]. What are you using GOTO for?
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
its better not to use goto statement. try to use some alternate to perform the functionality.
Do good and have good.