You can teach an old dog new tricks! Mythbusters proved that one 🙂

Coming from an Oracle background, I always use semi-colons, but strangely SSRS (using BIDS 2008) removes them automatically when you use them (in the rare event that I don't used a stored proc)

If you use Openquery from SQL Server to Oracle with the OraOLEDB.Oracle provider it returns an error "invalid character" if you use a semicolon in the passed-through query.

It might be ANSI but it's not consistently applied.