Sybase ASE
All versions
Last updated: 26 January 2020
ASE Quiz Questions
This page contains some quiz-type ASE questions to test your ASE knowledge; a little diversion for those moments when there's nothing better to do.
Please note that these questions are not intended as test questions for ASE certification exams: they'll rather be about strange, obscure, bizarre or little-known ASE features. Also, these might well be solutions for which we haven't found a problem yet... (but it might help your certification exam preparations anyway...).

It is my intention to add a new question every month, but sometimes things are just too busy...

Also available: the Quiz Question Randomizer. Try it here!

January 2020
Recently, I noticed the following lines in an ASE customer's application (the procedure was not called 'myproc', I simplified it for this quiz question):
   if @stat = 3
      exec myproc 

I was confused at first. Does ASE secretely support the IF...ENDIF syntax or there something else going on?

Go here for the answer.

More ASE quiz questions: 2013 - 2012 - 2011 - 2010 - 2009 - 2008 - 2007 - 2006 - 2005 - 2004 - 2003 - 2002 - 2001
For a randomly selected quiz question, click here.

 This document is located at