## SQL Server 2012 Functions Recipes

This book is a basic introduction to SQL Server 2012 Functions with Practical Implementation for beginners.

• Published on Oct 28 2013
• Pages 81
• Type PDF
• Like
• Love It
• Awesome
• Interesting
• It's Okay
• Thumbs Down
• 18.5k
• 0

## Introduction:

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.

1. Analytic Function

1.1 First_Value Function (New Function)
1.2 Last_Value Function (New 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.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.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