Slava Murygin has fun calculating Pi in SQL Server:
It goes like:
N1 BaseType : numeric
N1 Precision : 10
N1 Scale : 0Interesting to know. SQL Server interprets integers higher than 2,147,483,647 as Numeric, not as BIGINT !!!
Slava digs up a couple T-SQL edge cases worth noting.