SQL Server Function Reference

SQL Server SQRT() Function

Learn how to use the SQL Server SQRT numeric function for calculations in SQL.

Syntax

SQRT(number)

Basic Example

SELECT SQRT(price) AS result
FROM products;

When to use it

Use SQRT when you need a numeric operation in SQL Server. This page is designed as a quick reference for developers, analysts, and students comparing SQL dialects.

Common mistake

A common mistake is copying syntax from another SQL dialect. Always verify function name, argument order, and formatting tokens for SQL Server.

Related SQL Functions

MySQL ROUND() Function
MySQL CEIL() Function
MySQL FLOOR() Function
MySQL ABS() Function
MySQL MOD() Function
MySQL POWER() Function

FAQ

Is SQRT available in every SQL database?

Not always. Function names and argument behavior can differ across SQL engines.

Can I use this in SELECT queries?

Yes. Most SQL functions are commonly used in SELECT and often in WHERE, ORDER BY, and GROUP BY depending on the function.