Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ASCII Character Groups in String Expand / Collapse
Author
Message
Posted Saturday, September 8, 2012 12:43 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 11:20 AM
Points: 305, Visits: 1,658
Comments posted to this topic are about the item ASCII Character Groups in String
Post #1356405
Posted Monday, September 10, 2012 7:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 25, 2016 5:11 PM
Points: 63, Visits: 121
What's the reasoning behind using the IF... GOTO Next; instead of using a Case statement?
I'm assuming the Case would execute faster, but regardless, I think it would be easier to follow.
I learned way back in 1981 in computer class, working on a statistics program for the football team, (written in BASIC) that the GOTO statement easily lead to nightmarish code, and that they are generally very easy to avoid, as in this case.
Post #1357092
Posted Monday, May 9, 2016 1:25 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:30 AM
Points: 7,902, Visits: 768
Thanks for the script.
Post #1784508
Posted Monday, May 9, 2016 1:31 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 11:20 AM
Points: 305, Visits: 1,658
There was no CASE statement in sql server 2005. All my GOTOs jump to the same place. I'm not one to discard any command or specialty tool although I agree the GOTOs of the '80s were excessive.

Please feel free to offer updated versions of anything I do online.
Post #1784521
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse