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
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 … 10 11 12 13
  • Books
  • Testimonials
  • Privacy Policy

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