XML in a text variable and dynamic query for MySQL

• lucazav

  SSC Eights!

  Points: 981

  More actions

  September 9, 2009 at 1:52 pm

  #72870

  Hi all!

  I have a MySQL linked server (MYSQLLNKD) in my SQL Server 2005. I need to get the xml output of a SQL Server view, convert it in a text variable (because it is more than 8000 chars), and than execute a procedure in MySQL having it as parameter.

  In order to execute a procedure in MySQL, I have to launch this query in SQL Server:

  EXECUTE('CALL mysql_proc(''' + @xmlText + ''')') AT MYSQLLNKD

  but I know I can't concatenate text and strings. I also can't convert text to varchar, because I have more than 8000 chars...

  So, how can I solve this issue??

  Thanks a lot in advantage for your help!

• lucazav

  SSC Eights!

  Points: 981

  More actions

  September 9, 2009 at 2:08 pm

  #1051434

  I'm sorry, this is the wrong section for this thread... Can any admin move it to "T-SQL (SS2K5)"? Thank you