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.

Kevin Feasel

2017-08-04

T-SQL