Yahoo Poland Wyszukiwanie w Internecie

Search results

1. www.w3schools.com › SQL › func_sqlserver_roundSQL Server ROUND() Function - W3Schools

   www.w3schools.com › SQL › func_sqlserver_round

   • Zapisane w pamięci cache

   Learn how to use the ROUND () function to round a number to a specified number of decimal places in SQL Server. See syntax, parameters, examples and technical details.

2. learn.microsoft.com › en-us › sqlROUND (Transact-SQL) - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   When length is a positive number, numeric_expression is rounded to the number of decimal positions specified by length. When length is a negative number, numeric_expression is rounded on the left side of the decimal point, as specified by length. function.

3. stackoverflow.com › questions › 10380197Rounding off to two decimal places in SQL - Stack Overflow

   stackoverflow.com › questions › 10380197

   29 lip 2021 · SET @Result = CEILING(@Value * POWER(10, @Decimals)) / POWER(10, @Decimals) where @Value is the value of the item to be rounded, @Decimals is the number of decimal places, for example, two in this instance. edited Jul 29, 2021 at 21:50. Peter Mortensen.

4. ittalk.pl › funkcje-sql-server › funkcja-mssql-round-jak-obliczycFunkcja MSSQL ROUND. Jak obliczyć? - ITTalk.pl

   ittalk.pl › funkcje-sql-server › funkcja-mssql-round-jak-obliczyc

   • Zapisane w pamięci cache

   26 mar 2023 · Składnia funkcji SQL Server ROUND jest następująca: ROUND (wartość, liczba_miejsc_po_przecinku) Gdzie wartość jest liczbą, którą chcemy zaokrąglić, a liczba_miejsc_po_przecinku jest liczbą miejsc po przecinku, do których chcemy zaokrąglić wartość.

5. www.sqlservertutorial.net › sql-server-math-functions › sql-server-roundSQL Server ROUND() Function

   www.sqlservertutorial.net › sql-server-math-functions › sql-server-round

   • Zapisane w pamięci cache

   Learn how to use the SQL Server ROUND () function to round a number to a specified precision. See the syntax, examples, and rounding algorithm of the ROUND () function.

6. www.mssqltips.com › sqlservertip › 1589SQL Server Rounding Functions - Round, Ceiling and Floor

   www.mssqltips.com › sqlservertip › 1589

   • Zapisane w pamięci cache

   20 lip 2021 · In addition, depending on the SQL Server rounding function (ROUND(), CEILING(), FLOOR()) used in the calculation the values can differ as well. As such, it is important to find out the user rounding requirements then translate those requirements into the appropriate T-SQL command.

7. www.mssqltips.com › sqlservertip › 7702SQL Round Function to Round Numbers Up or Down - SQL Server Tips

   www.mssqltips.com › sqlservertip › 7702

   • Zapisane w pamięci cache

   14 cze 2023 · How can I round values for data representation and how does rounding work in SQL Server? In this SQL tutorial, we will learn how to use SQL ROUND() function through various examples to round values with different lengths in a SQL database.