Xml And Sql Server

XML path methode

SELECT [usr_stateMachineInfo]  
  FROM [dbo].[Users]
  WHERE  [dbo].[Users].usr_id='93'   
  FOR XML path('root')

XML RAW methode

SELECT usr_id,usr_user_name,[usr_stateMachineInfo]  
  FROM [dbo].[Users]
  FOR XML RAW, ELEMENTS 
retourne 

  93
  demo_demo
  text

détaille
http://www.programmersheaven.com/2/SQL-server-2005-school-lesson-5