SQL Server's 'Wrong' Math

preview_player
Показать описание
Sometimes SQL queries that include numerical calculations can produce some unintended results. This week we look at why sometimes SQL Server produces "wrong" mathematical results.

Check out the related blog post for all code samples:

Follow me on Twitter:
  1. Bert Wagner
  2. SQL Server
  3. sql math
  4. incorrect sql math
  5. wrong sql equation
  6. sql server rounding error
Рекомендации по теме
SQL Server's 'Wrong' 0:05:03

SQL Server's 'Wrong' Math

SQL Server's 'Wrong' 0:13:42

SQL Server's 'Wrong' Math - Part 2 - Floating Point Errors

Mathematical functions in 0:11:55

Mathematical functions in SQL server | SQL Tutorial | Sekharmetla | Harisystems

The EASIEST Way 0:03:29

The EASIEST Way To Find SQL Query Errors

Space Calculation for 0:03:02

Space Calculation for SQL Server Table: What's wrong with my query?

18 SQL Server 0:08:54

18 SQL Server Performance Tasting Menu Date Math Matters

Are SQL Server 0:06:44

Are SQL Server Subqueries Bad??

Mathematical Functions In 0:11:13

Mathematical Functions In Sql Server

SQL : SQL 0:01:25

SQL : SQL Server Arithmetic overflow error converting expression to data type datetime

The Importance of 0:51:38

The Importance of Wait Statistics in Monitoring SQL Server

An Introduction to 1:13:36

An Introduction to Wait Statistics in SQL Server

Date Math Annoyances 0:12:37

Date Math Annoyances In SQL Server Queries

SQL Quiz | 0:00:23

SQL Quiz | Can a Column Name Start with a Number?

Common SQL Server 1:23:44

Common SQL Server Mistakes and How to Avoid Them

SQL Server Performance 1:03:35

SQL Server Performance Tuning Made Easy

Why Logical Reads 0:17:13

Why Logical Reads Are A Bad Metric For Query Tuning In SQL Server

6 Query Tuning 1:37:51

6 Query Tuning Techniques - Solve 75% SQL Server Performance Problems (by Amit Bansal)

Common SQL Server 1:02:41

Common SQL Server Mistakes with Tim Radney - Alaska SQL User Group 05-14-15

identity column in 0:01:01

identity column in #sql

Group By With 0:00:40

Group By With Average Function In Sql SERVER | Part 15 #sqlserver #coding #dataqueries

Understand Statistics in 0:11:08

Understand Statistics in SQL Server for better performance troubleshooting

End to End 1:20:06

End to End Troubleshooting for SQL Server

Approach to Complex 0:08:33

Approach to Complex SQL Queries

SQLug.se - Kevin 1:06:42

SQLug.se - Kevin Boles - SQL Server Defaults SUCK!!, session 2

Комментарии
Автор

Why the heck do you only have < 3k Your tips are awesome and are a great speaker. Keep up the great work!

CenterpointConnect
Автор

Data type precedence doesn't really effect the first expression, all the values are an int, so there is no implicit conversion. It's only when you use 16.(0) or 16e0 that is becomes a fact when the value is a decimal/float respectively. At that point the expression returned within the parenthesis is converted "upwards" to the appropriate data type (with the highest data type precedence).

LarnuUK
Автор

Great tutorial!!! What's the code when you cast. Are you casting as decimal or INT? I've run into problems with the number of zeros when casting equations as DECIMAL or as an INT with division. Thanks.

StoryboardLifePhoto
Автор

Great videos like others in this channel) you got a new subscriber!

raufasadov
Автор

Ouch, painful video to watch - the video was great, but the memories it evoked, of an insurance system I built a long time ago (before learning this lesson)...

Thanks for a great vid, Bert. As always, really entertaining and educational... Your channel is much better than MVA (IMHO) :-)

zanonilabuschagne
Автор

What about numbers of precision? How does SQL Server choose how many zeroes if it’s calculating numericals with different levels?

shopsmartin