This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Two rounded stones rest on a sage-green mat, while a dark blue stone rests on a separate slate-blue mat beside a knotted cord.

geometry SRID Mismatch: NULL Is Not a Zero Distance

June 6, 2007
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL NULL, SQL Server

geometry SRID mismatch is different from coincident points. Keep both identifiers beside the distance and preserve the distinction between NULL and zero.

Read More
Gouache painting: in a gym corner, nine crisp foam tiles lock together into a perfect square

SQUARE: Expect a float Result From Numeric Inputs

May 14, 2007
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL NULL, SQL Server

SQUARE accepts numeric inputs convertible to float and returns float. Explicit decimal display keeps this small example readable without claiming exact decimal multiplication.

Read More
A baguette resting in a slotted wooden slicing guide, a few slices cut and the long uncut end beside a red cloth.

SQRT: Keep Fractional Roots in the Result

January 20, 2007
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL NULL, SQL Server

SQRT produces an approximate square root. These read-only examples preserve fractional roots, state the display precision and distinguish a missing input from zero.

Read More
Previous 1 … 9 10 11 12
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com