mickyT (9/24/2012)
Shame there isn't implicit conversion for money to int in the followingSELECT -(~$)
It would have made a good answer
If ^ was a POWER operator, you could do:
SELECT $^$
Alas, it's the word POWER:
SELECT Power($,$)
Ahh, the power of money. 😀
I like this one, as it always annoyed me that IsNumeric says it's a number:
SELECT IsNumeric('.')
and this one, because everyone loves a bit of pie:
SELECT Convert(Bit, Pi())
Here's some others I don't think I've seen listed yet...
SELECT @@SPID/@@SPID
SELECT Min(Principal_ID) FROM Sys.Server_Principals