Quick examples of PI(), POWER() and EXP() in SQL Server, and the answer to the title: EXP to the POWER of PI returns 23.1406926327793.
SQL SERVER – FIX : ERROR Msg 244, Level 16, State 1 – FIX : ERROR Msg 245, Level 16, State 1
Msg 244 and Msg 245 come from converting a value to an incompatible data type, often with CAST or ISNULL. Examples of both, and why ISNULL casts to the first type.
Explaining a Database to Non-Programmers (It Won’t Play Your Flash Movie)
Explaining a database to non-programmers is a real skill. Here’s my old flash movie story and the plain comparisons that work in any meeting.
SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT
How to convert text to integer with CAST and CONVERT, whether they fail on alpha-numeric values (yes), and how to pull only the numbers from a string.
SQL SERVER – FIX : Error : msg 8115, Level 16, State 2, Line 2 – Arithmetic overflow error converting expression to data type
Msg 8115, arithmetic overflow error, comes when a value is too big for its column, like 111111 in a TINYINT. Check the value or widen the column definition.
SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9
Microsoft Document Explorer cannot be shown when you open a new SQL Server Books Online? Uninstall every Books Online version, then install it again.
SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example
A simple Best Practices Analyzer Tutorial with images, run on an old laptop with SQL Server 2005 and many planted issues, to help you start using BPA.