XML type variable : Variable « Transact SQL « SQL Server / T-SQL Tutorial

4> DECLARE @Book XML
5> SET @Book =
6> CAST('<Book name="SQL Server 2000 Fast Answers">
7~ <Chapters>
8~ <Chapter id="1"> chapter 1 </Chapter>
9~ <Chapter id="2"> chapter 2 </Chapter>
10~ <Chapter id="3"> chapter 3 </Chapter>
11~ <Chapter id="4"> chapter 4 </Chapter>
12~  </Chapters>
13~  </Book>' as XML)
14> GO
1>
2>

20.2.Variable
	20.2.1.	Working with Variables
	20.2.2.	Use right function with a variable
	20.2.3.	Testing the ISNULL function
	20.2.4.	SELECT LEFT(@FullName, 5)
	20.2.5.	Global variable names begin with an @@ prefix.
	20.2.6.	XML type variable
	20.2.7.	Varchar type variable
	20.2.8.	Use if statement to check a variable
	20.2.9.	A variable can be assigned a value from a subquery
	20.2.10.	Use aggregate function with variables
	20.2.11.	Use Local Variables in where clause
	20.2.12.	A SQL script that uses variables
	20.2.13.	Local variables used for searches
	20.2.14.	Pass variable to a user-defined function
	20.2.15.	Use one variables in like function