ASE Quiz Question Randomizer
 
Randomly selected quiz question (want a different question? Click here):


October 2003
Syntax errors normally cause the execution of SQL code to be aborted. However, syntax errors can also have unexpected side-effects. Can you see the difference between the following batches, which both contain incorrect syntax?
-- batch 1
insert MyTable   
vlaues (1)      -- should have been 'values'
select * from MyTable
go

-- batch 2
inset MyTable   -- should have been 'insert'
select Col from YourTable
select * from MyTable
go
(Hint: there are no tricks with the tables themselves: MyTable and YourTable both exist and contain a single int column named Col)


Click 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 www.sypron.nl/quizrand.html