Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mcobrien
-
Dynamic Stored Procedure call
Looks like you can't join the procedure name and the variables in the one string. I can't find anything in the manuals stating this - but I know below should work: select @statement = "proc_glove_1" select @a = {your first variable value}, @b = {your 2nd variable value} Exec...- mcobrien
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
phonetic search
Yup - the string function SOUNDEX(String). Not that I've ever used it...- mcobrien
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
Date validation
I got around the same problem (bad February dates in char fields) by validating as a string. For example, when the date is in YYYYMMDD format e.g. ("20000231"): If substring(@date, 5, 2) = "02" and convert(int, substring(@date, 7, 2)) > 29 print "error"...- mcobrien
- Post #4
- Forum: Sybase: Adaptive (SQL) Server
-
Stored procedure calling code section
The GOTO statement allows you to jump to a specific code section. 1. Provide a label for your code section (e.g. DoStuff). Don't forget the colon. DoStuff: Select col_a from table_b 2. Use GOTO to jump to the code section. GOTO DoStuff- mcobrien
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
