Page 17 - SQL
P. 17
Removing all rows from the Employee table 184
Chapter 59: TRY/CATCH 186
Remarks 186
Examples 186
Transaction In a TRY/CATCH 186
Chapter 60: UNION / UNION ALL 187
Introduction 187
Syntax 187
Remarks 187
Examples 187
Basic UNION ALL query 187
Simple explanation and Example 188
Chapter 61: UPDATE 190
Syntax 190
Examples 190
Updating All Rows 190
Updating Specified Rows 190
Modifying existing values 190
UPDATE with data from another table 191
Standard SQL 191
SQL:2003 191
SQL Server 191
Capturing Updated records 192
Chapter 62: Views 193
Examples 193
Simple views 193
Complex views 193
Chapter 63: Window Functions 194
Examples 194
Adding the total rows selected to every row 194
Setting up a flag if other rows have a common property 194
