从XML中选择SQL Server中的值

I have this XML:

我有这个XML:

 <SearchResponse>
    <Data>
        <Information>
            <Code>Code 1</Code>
            <Options>
                <Option>
                    <TID>1</TID>
                    <Rooms>
                        <ReturnRoom>
                            <RoomId>1</RoomId>
                            <Description>Single</Description>
                        </ReturnRoom>
                        <ReturnRoom>
                            <RoomId>2</RoomId>
                            <Description>Standard</Description>
                        </ReturnRoom>
                    </Rooms>
                </Option>
                <Option>
                    <TID>2</TID>
                    <Rooms>
                        <ReturnRoom>
                            <RoomId>1</RoomId>
                            <Description>Single</Description>
                        </ReturnRoom>
                    </Rooms>
                </Option>
            </Options>
        </Information>      
    </Data>
</SearchResponse>
 <SearchResponse>