Yahoo Αναζήτηση Διαδυκτίου

Sign In

Αποτελέσματα Αναζήτησης

  1. stackoverflow.com › questions › 63447How do I perform an IF...THEN in an SQL SELECT?

    15 Σεπ 2008 · The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server. SELECT CAST( CASE WHEN Obsolete = 'N' or InStock = 'Y' THEN 1 ELSE 0 END AS bit) as Saleable, * FROM Product

  2. www.w3schools.com › sql › func_sqlserver_formatSQL Server FORMAT() Function - W3Schools

    1 Δεκ 2018 · The FORMAT () function formats a value with the specified format (and an optional culture in SQL Server 2017). Use the FORMAT () function to format date/time values and number values. For general data type conversions, use CAST () or CONVERT ().

  3. www.mssqltips.com › sqlservertutorial › 9354SQL FORMAT Function Use and Examples - SQL Server Tips

    3 Νοε 2021 · Learn how to format numbers, dates, time and money using the SQL Server FORMAT function.

  4. www.datacamp.com › tutorial › format-sql-functionFORMAT() SQL FUNCTION - DataCamp

    12 Οκτ 2022 · FORMAT() turns numbers or datetimes into text, with rules for how they are displayed. When to use FORMAT() FORMAT() comes in handy for displaying dates, currency, and numeric values in a specific format.

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

    2 ημέρες πριν · Returns a value formatted with the specified format and optional culture. Use the FORMAT function for locale-aware formatting of date/time and number values as strings. For general data type conversions, use CAST or CONVERT. Transact-SQL syntax conventions.

  6. www.sqlshack.com › a-comprehensive-guide-to-the-sql-format-functionA comprehensive guide to the SQL Format function - SQL Shack

    11 Μαρ 2020 · We have a new function, SQL FORMAT, from SQL Server 2012. We use this new function to get output in a specified format and Culture. It returns an NVARCHAR data type in the output. Syntax of SQL FORMAT Function. FORMAT (value, format [, culture]) It has the following parameters: Value: It is the value to do formatting. It should be in support of ...

  7. database.guide › how-to-apply-conditional-formatting-to-a-number-in-sql-serverHow to Apply Conditional Formatting to a Number in SQL Server...

    2 Ιουλ 2019 · You can pass a format string that specifies how the number should be formatted, depending on whether it’s positive, negative, or zero. Just to be clear, I’m not talking about formatting the number with colors or fonts etc.

  1. Αναζητήσεις που σχετίζονται με select if sql statement format string

    select if sql statement format string example
    select if sql statement format string contains
    if sql statement
    select if sql statement format string function
    select if sql
    select if sql statement format string type
    select if sql statement format string name
    select if sql statement format string value
    select if sql statement format string length
    select if sql statement format string variable
    select if sql statement format string size
    select if sql statement format string exists
  2. Γίνεται επίσης αναζήτηση για