This book is a basic introduction to SQL Server 2012 Functions Recipes basically for beginners who want to learn complete basic with example of SQL Server 2012 Functions.

Table of Contents

1. Analytic Function

    1.1 First_Value Function (New Function)
    1.2 Last_Value Function (New Function)
    1.3 Lead Function

2. Conversion Functions

    2.1 Cast Function
    2.2 Convert Functions
    2.3 Parse Function - (New Function)
    2.4 Try_Parse Function - (New Function)
    2.5 Try_Convert Function - (New Function)

3. Date and Time Functions

    3.1 Higher-Precision System Date and Time Functions

        3.1.1 SYSDATETIME
        3.1.2 SYSDATETIMEOFFSET
        3.1.3 SYSUTCDATETIME

    3.2 Lower-Precision System Date and Time Functions

        3.2.1 CURRENT_TIMESTAMP
        3.2.2 GETDATE
        3.2.3 GETUTCDATE

    3.3 Date and Time Parts Functions

        3.3.1 Datepart Function
        3.3.2 DateName function
        3.3.3 Year Function
        3.3.4 Month Function
        3.3.5 Day Function

    3.4. Date and Time Values from Their Parts Functions

        3.4.1 DATEFROMPARTS Function - (New Function)
        3.4.2 TIMEFROMPARTS Function - (New Function)
        3.4.3 DATETIMEFROMPARTS Function - (New Function)

    3.5. Functions That Modify Date and Time Values

        3.5.1 DATEADD Function
        3.5.2 EOMONTH Function
        3.5.3 TODATETIMEOFFSET Function

4. Important Data Type Functions

    4.1 DataLength Function
    4.2 IDENT_Current Function

5. Logical Functions

    5.1 Choose Function -(New Function)
    5.2 IIF Function - (New Function)

6. Mathematical Numeric Functions

    6.1 ABS (number) Function
    6.2 Celling (number) Function
    6.3 Floor (number) Function
    6.4 Suare Function
    6.5 Round Function
    6.6 IsNumeric Function
    6.7 Degrees Function

7. Metadata Functions

    7.1 DB_NAME Function
    7.2 Host_Name Function
    7.3 APP_NAME Function

8. Ranking Functions

    8.1 ROW_NUMBER
    8.2 RANK
    8.3 DENSE_RANK
    8.4 NTILE

9. Rowset Function

    9.1 Openxml function

10. String Functions

    10.1 CharIndex Function
    10.2 PatIndex Function
    10.3 Format Function - (New Function)
    10.4 Concat Function - (New Function)
    10.5 Left Function
    10.6 Right Function
    10.7 Ltrim Function
    10.8 Rtrim Function
    10.9 QuoteName Function
    10.10 Stuff Function
    10.11 Replace Function
    10.12 Space Function
    10.13 Substring Function
    10.14 Unicode Function
    10.15 Nchar Function
    10.16 Len Function
    10.17 Lower Function
    10.18 Upper Function

11. Some Important system error functions in SQL Server

    11.1 ERROR_LINE Function
    11.2 ERROR_NUMBER Function
    11.3 ERROR_STATE Function
    11.4 ERROR_SEVERITY Function

12. Aggregate Function

    12.1 Min Function
    12.2 Max Function
    12.3 Sum Function
    12.4 Avg Function
    12.5Count Function