Without running the following two blocks of code what do you think will the output be?
/* code 1
SELECT GETDATE()
GO */
SELECTGETDATE()
/* code 2
SELECT GETDATE()
GO
*/
SELECTGETDATE()
3 comments:
Anonymous
said...
SELECT GETDATE() produces exactly what is expected, provided you allow for the time it takes in between the first SELECT GETDATE() and the second SELECT GETDATE()
3 comments:
SELECT GETDATE() produces exactly what is expected, provided you allow for the time it takes in between the first SELECT GETDATE() and the second SELECT GETDATE()
what was the point of this teaser?
Rudy,
It is not the select date, it is the GO that will throw an error on the 2nd code piece
Denis
I don't have 2005 to test with at the moment, but it doesn't throw an error on my SQL 2000 system.
Post a Comment