Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

assign xml type variable to another variable Expand / Collapse
Author
Message
Posted Thursday, December 09, 2010 4:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 09, 2012 1:43 AM
Points: 49, Visits: 198
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?
Post #1032372
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse