Home / Questions / 6263
Accepted
MBahamondes
Asked: 2020-03-25 06:08:56 +0800 CST 2020-03-25 06:08:56 +0800 CST

What does this statement do with the exclamation mark?

  • 772

I am looking at a query that generates a certain result and I find a statement like this:

SELECT tabla!columna AS alias FROM tabla

My doubt is that it performs the sign !, I tried it on Access 2007 -2010and it works, but I don't understand the logic.

And will it be compatible with some version of SQL Server?

base-de-datos

1 Answers

  1. Best Answer

    This is non-standard Access syntax.

    It is equivalent to:

    SELECT tabla.columna AS alias FROM tabla
    • 2