Microsoft® SQL Server® 2012 Bible

307 Chapter 12: Modifying Data In SQL Server 12 SELECT EmployeeID, Salary, CAST(CAST(DATEDIFF(d, DateHire, '20120625') AS DECIMA ...

308 Part II: Building Databases and Working with Data Result: EmployeeID Salary EmpRaise ----------- ------------ -------------- ...

309 Chapter 12: Modifying Data In SQL Server 12 AS DECIMAL(7, 2)) / 365.25 AS INT) * .1) -- months in position  + (CAST(CAST(DAT ...

310 Part II: Building Databases and Working with Data The SQL UPDATE command is powerful. The terribly complex record sets and n ...

311 Chapter 12: Modifying Data In SQL Server 12 Referencing Multiple Data Sources While Deleting You can use two techniques for ...

312 Part II: Building Databases and Working with Data Cascading Deletes Referential integrity (RI) refers to the idea that no se ...

313 Chapter 12: Modifying Data In SQL Server 12 REFERENCES [HumanResources].[Employee] ([BusinessEntityID]) ON DELETE CASCADE GO ...

314 Part II: Building Databases and Working with Data Merging Data An upsert operation is a logical combination of an insert and ...

315 Chapter 12: Modifying Data In SQL Server 12 Seat CHAR(3) NOT NULL ); INSERT FlightPassengers (LastName, FirstName, FlightCod ...

316 Part II: Building Databases and Working with Data AND C.FlightDate = F.FlightDate WHERE C.LastName IS NULL Result: Passenger ...

317 Chapter 12: Modifying Data In SQL Server 12 Result: Passenger previous seat final seat --------------------------- --------- ...

318 Part II: Building Databases and Working with Data ON C.LastName = F.LastName AND C.FirstName = F.FirstName AND C.FlightCode  ...

319 Chapter 12: Modifying Data In SQL Server 12 For more examples of the inserted and deleted table, turn to Chapter 18, “Buildi ...

320 Part II: Building Databases and Working with Data Result: OldFirstName OldLastName NewFirstName NewLastName ---------------- ...

321 Chapter 12: Modifying Data In SQL Server 12 Result: FlightID LastName Seat $action FlightID LastName Seat --------- -------- ...

322 Part II: Building Databases and Working with Data Summary Data retrieval and data modifi cation are primary tasks of a datab ...

Part III Advanced T-SQL Data Types and Querying Techniques IN THIS PART Chapter 13 Working with Hierarchies Chapter 14 Using XML ...

c13.indd 324c13.indd 324 7/30/2012 4:47:03 PM7/30/2012 4:47:03 PM http://www.it-ebooks.info ...

325 CHAPTER 13 Working with Hierarchies IN THIS CHAPTER Using HierarchyID Understanding Hierarchical Data Alternatives E ver sin ...

326 Part III: Advanced T-SQL Data Types Querying Techniques This chapter primarily focuses on the HierarchyID data type because ...