SELECT $
is equivalent to
SELECT $0.00
.
SQL Server uses the $ to indicate a
Money
Data Type. The documentation shows many different kinds of currency symbols that SQL Server recognizes.
See
money and smallmoney (Transact-SQL)[
^] documentation.
Prove to yourself that SQL Server uses the $ to indicate a
Money
Data Type by entering this query into SQL Server Management Studio:
select $2^3
or
select $^3
The error returned will be
Msg 402, Level 16, State 1, Line 1<br />
The data types money and int are incompatible in the '^' operator.
The error message talks about two data types.
$2 being the
Money
value and 3 being the
int
value.