Sql server® 2012 t-sql fundamentals

FORMAT function

402  

Index

FORMAT function,  71

forms

external forms,  160

column aliases in CTEs,  164

inline aliasing form,  160

four-valued predicate logic,  6

framing

aggregate functions,  221

window functions,  213

FROM

about, 29

cross joins,  100

DELETE, 262

DELETE based on joins,  264

derived tables,  162

multi-join queries,  116

multiple references in CTEs,  166

table UDFs,  362

FROMPARTS function,  87

FULL, outer joins,  110

functions

@@identity function,  254

aggregate functions,  35

CAST function,  138

CHARINDEX function,  67

CHOOSE function,  55

COALESCE function,  66

COLUMNPROPERTY function,  90

CONCAT function,  64

CONVERT function,  77

CURRENT_TIMESTAMP function,  80

DATABASEPROPERTYEX function,  90

DATALENGTH function,  67

date and time functions,  80–87

DB_NAME function,  305

ERROR_LINE function,  371

ERROR_MESSAGE function,  371

ERROR_NUMBER function,  371

ERROR_PROCEDURE function,  371

ERROR_SEVERITY function,  371

ERROR_STATE function,  371

EVENTDATA function,  368

FIRST_VALUE function,  218

FORMAT function,  71

GETDATE function,  80

GROUPING and GROUPING_ID functions,  236–

238

IDENT_CURRENT function,  254

IIF function,  55

ISNULL function,  55

LAG function,  217, 243

LAST_VALUE function,  218

LEAD function,  217, 243

LEFT and RIGHT functions,  66

LEN function,  67

LOWER function,  70

LTRIM function,  70

NEWID function,  363

NEXT VALUE FOR function,  258, 281

NTILE function,  215

OBJECT_DEFINITION function,  173

OBJECT_NAME function,  305

OBJECTPROPERTY function,  90

ORDER BY and  window functions,  196

PATINDEX function,  68

RAND function,  363

ranking functions,  215

REPLACE function,  68

REPLICATE function,  69

ROW_NUMBER function,  48, 196, 215, 276

RTRIM function,  70

SCHEMA_NAME function,  88

SCOPE_IDENTITY function,  254, 280

STUFF function,  70

SUBSTRING function,  66

SYSDATETIME function,  25, 80

SYSDATETIMEOFFSET function,  80

sys.dm_exec_sql_text function,  306

system stored procedures and functions,  89

SYSUTCDATETIME function,  80

TRY_CAST function,  81

TRY_CONVERT function,  81

TRY_PARSE function,  81

UDFs, 362

UPPER function,  70

window functions

about, 48

aggregates,  220, 352

offset window functions,  217–219

ORDER BY,  196

ranking, 214–217

G

GETDATE function,  80

getting started,  375–396

downloading source code,  385

installing the sample database,  385

Microsoft SQL Server Books Online,  393–396

www.it-ebooks.info

---