assign xml type variable to another variable

• kuppurajm

  SSCommitted

  Points: 1593

  More actions

  December 9, 2010 at 4:55 am

  #388402

  Hi all,

  I need to assign xml type variable to another xml type variable without

  using convert(varchar)

  my code is

  --------------

  declare @data xml

  set @Data1=convert(varchar(max),@Data)

  it works fine

  because of varchar(max) limitation(8000 char) I need to assign this without converting.

  How it is possible?